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
| 1234 | g |
| 1,234.00 | N |
| 1234 | D0 |
| 1234.00 | F |
| 1.234123e+003 | e |
Date
| 9/21/2009 10:06 AM | g |
| Monday, September 21, 2009 | D |
| 9/21/2009 | d |
Time
| 9/21/2009 10:06 AM | g |
| 10:06:25 AM | T |
| 10:06 AM | t |
Percentage
| 123,400.00 % | P |
| 123,400 % | P0 |
Currency
| $1,234.12 | C |
It completely agree with told all above.
Excuse for that I interfere … At me a similar situation. Let's discuss. Write here or in PM.
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);