Monday, September 21, 2009

SSRS Format codes

If you use SQL Server Reporting Services (SSRS), then you have probably used the "Format Code" setting when desiging a report. But what codes are available, and where can you find a list of them? Below is a list of what I have been able to find, it may not be complete, but its a start:

Number






1234g
1,234.00N
1234D0
1234.00F
1.234123e+003e

Date





9/21/2009 10:06 AMg
Monday, September 21, 2009D
9/21/2009d

Time





9/21/2009 10:06 AMg
10:06:25 AMT
10:06 AMt

Percentage




123,400.00 %P
123,400 %P0
Currency



$1,234.12C

3 comments:

Anonymous said...

It completely agree with told all above.

Anonymous said...

Excuse for that I interfere … At me a similar situation. Let's discuss. Write here or in PM.

justcomp said...

Thanks a lot this page help a lot.
I would like to add date format which is "d" "mm/dd/yyyy" and MMM-YY like MAR-10,

Thanks.....javascript:void(0);