Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Formatting, Formatting, Formatting! Expand / Collapse
Author
Message
Posted Thursday, April 10, 2008 7:07 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:54 AM
Points: 319, Visits: 782
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.
Post #482997
Posted Thursday, April 10, 2008 1:22 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 31, 2009 7:53 AM
Points: 150, Visits: 642
Try this in expression

Round(21.1254045578,2)& "%"

Results is as
= 21.13%

Hopefully this is close enough for you :)


“I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison
Post #483258
Posted Friday, April 11, 2008 4:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:54 AM
Points: 319, Visits: 782
Thanks for your help.
Post #483551
Posted Thursday, April 24, 2008 7:12 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 16, 2010 9:31 AM
Points: 62, Visits: 184
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 ]
Post #489894
Posted Wednesday, April 06, 2011 11:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 08, 2011 11:24 AM
Points: 6, Visits: 9
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
Post #1089696
Posted Thursday, April 07, 2011 7:59 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:16 PM
Points: 2,812, Visits: 2,543
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.
Post #1089906
Posted Thursday, April 07, 2011 8:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 08, 2011 11:24 AM
Points: 6, Visits: 9
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
Post #1090344
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse