logo
Formatting Numbers and Dates in RDLC Report

You can specify a format for numeric and date values by updating the Format property of its text box with a formatting string.
For example, you can set a text box for a numeric field to display the number as currency.
Reporting Services uses Microsoft .NET Framework formatting strings or you can create a custom formatting string for the Format property.

NoteNote:

To apply formatting to a text box, the text box must contain an expression, for example, =Fields!LineTotal.Value or =1000. If the text box is not an expression, that is, if the text in the text box does not begin with the equal (=) sign, then the text is interpreted as a string and formatting does not apply.

Formatting Numbers

The following table lists common .NET Framework number formatting strings.

Format String Name
C or c Currency
D or d Decimal
E or e Scientific
Formatting Numbers

You can specify a format for numeric and date values by updating the Format property of its text box with

NoteNote:

To apply formatting to a text box, the text box must contain an expression, for example, =Fields!LineTotal.Value or =1000. If the text box is not an expression, that is, if the text in the text

Formatting Numbers

The following table lists common .NET Framework number formatting strings.

Format String Name
C or c Currency
D or d Decimal
E or e Scientific