Formatting Numeric and Date Values in a 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.

ms157406.note(en-US,SQL.90).gifNote:
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.

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

F or f

Fixed-point

G or g

General

N or n

Number

P or p

Percentage

R or r

Round-trip

X or x

Hexadecimal

You can modify many of the format strings to include a precision specifier that defines the number of digits to the right of the decimal point. For example, a formatting string of D0 formats the number so that it has no digits after the decimal point. You can also use custom formatting strings, for example, #,###.

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

Format string Name

d

Short date

D

Long date

t

Short time

T

Long time

f

Full date/time (short time)

F

Full date/time (long time)

g

General date/time (short time)

G

General date/time (long time)

M or m

Month day

R or r

RFC1123 pattern

Y or y

Year month

You can also a use custom formatting strings; for example, dd/MM/yy. For more information about .NET Framework formatting strings, see "Formatting Types" at msdn.microsoft.com..

Community Additions

ADD
Show: