Formatting, Formatting, Formatting!
-
Hi All,
I wish I could understand how the formatting of numeric values works in SSRS.
I have a numeric value for example 21.1254045578 and I need to display this as 21.12%. Can someone please tell me how I can do this?
Thanks.
-
Try this in expression
Round(21.1254045578,2)& "%"
Results is as
= 21.13%
Hopefully this is close enough for you
[font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]
-
Thanks for your help.
-
Or how about this?
Right click the field, select Properties- Format Tab, put P2 in the format code field.
Here are some links to microsoft cheat sheets.
•FORMAT STRINGS
•Standard Numeric Format Strings [ http://msdn2.microsoft.com/en-us/library/aa720653(printer).aspx ]
•Custom Numeric Format Strings [ http://msdn2.microsoft.com/en-us/library/aa719871(printer).aspx ]
•Standard DateTime Format Strings [ http://msdn2.microsoft.com/en-us/library/aa720651(printer).aspx ]
•Custom DateTime Format Strings [ http://msdn2.microsoft.com/en-us/library/aa719856(printer).aspx ]
-
Hello all i need help i want someone to tell me SSN format how i can get SSN
i will really appreciate if any member can bill me out of this i will be very greatful
any member that know site i can even get SSN will be fantastic i look fordward if help
can come from anybody that can help
Thank you and God bless .
James
-
You really should have posted this in a new thread rather than posting it at the end of a 2 year old thread.
In the properties for the text box (not the Text Box Properties dialog box, but the regular advanced properties for the textbox) you will find a Number Format property. Put ###-##-#### into that property and you should be good to go.
-
Hi there can you please tell me which site is perfect to search for SSN
please kindly explain the Format for me so that i can understand better
is this the Format i should use to get SSN (###-##-####) ?
thank you for your responded i looked forward to hearing from you soon
once again big thanks to you for replying me back
James
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply