I have a textbox in the report footer that is summing a decimal field. How can I get that field to show only two decimal places? The below does not format at all.
Total Regulated Miles: {Format( "{{0:N2}}", CStr(Sum(Fields.MILES)))}
Total Regulated Miles: {Format( "{{0:N2}}", CStr(Sum(Fields.MILES)))}
1 Answer, 1 is accepted
0
Hi Brian,
Elian
the Telerik team
CStr(Sum(Fields.MILES)) converts the value to a string, but with the specified format the Format functions expects decimal number. So the following expression should do what you expect:
{Format("{{0:N2}}", Sum(Fields.MILES))}
Elian
the Telerik team
HAPPY WITH TELERIK REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!