Post reply

Formatting, Formatting, Formatting!

  • April 10, 2008 at 7:07 am

    #185305

    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.

  • April 10, 2008 at 1:22 pm

    #801158

    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]

  • April 11, 2008 at 4:56 am

    #801381

    Thanks for your help.

  • April 24, 2008 at 7:12 am

    #806549

    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 ]

  • April 6, 2011 at 11:59 pm

    #1308369

    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

    🙂

  • April 7, 2011 at 7:59 am

    #1308542

    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.

  • April 7, 2011 at 8:11 pm

    #1308918

    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