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.
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 NumbersThe 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 NumbersThe following table lists common .NET Framework number formatting strings.
Format String | Name |
---|---|
C or c | Currency |
D or d | Decimal |
E or e | Scientific |