Post reply

format related problem in SSRS: to show upto # decimal places

  • October 15, 2008 at 6:29 am

    #194682

    IN REPORTING SERVICES (SSRS)

    The expression in a cell is like

    =Sum(Fields!a.Value)/Sum(Fields!b.Value)

    in output .. i want to show upto 5 decimal places.

    Is this possible with a format string?? or any other solution??

  • October 15, 2008 at 6:45 am

    #885160

    If you only want 5 decimal places to show up you can use the following as your format string.

    #.#####

    The pound sign indicates that only 5 numbers should be shown after the decimal. If you always want 5 decimal places to show even for integers you can use zero's instead of pound signs.

    For example if you use #.##### as your format string , and the value is 5 it will display as 5.

    If the value is 5 and you use #.00000 as your format string, it will display as 5.00000.

    Please let me know if this helps.

  • October 15, 2008 at 6:54 am

    #885166

    Hello...

    Please try this once and let me knw if it helps...

    =Format(Sum(Fields!a.Value)/Sum(Fields!b.Value),"#.#####");

    Thanks,

  • October 15, 2008 at 6:56 am

    #885168

    this is a partial solution... thanks

    But if the value is calulated to "0"... then nothing is displayed in that cell

    where as output expected is "0.00000"

    similarly ... if the value is calculated to "0.123456789" .... then the output expected is "0.12345" .... and "#.#####" displays it as ".12345"

  • October 15, 2008 at 7:18 am

    #885182

    # - specifies an optional placeholder

    0 - specifies required placeholder

    Format(Table!Field.Value,"#0.00000")

    will always return 5 digits after comma.

  • October 15, 2008 at 7:29 am

    #885191

    thanks Glen Sidelnikov 🙂

    "#0.00000" worked!! 😀

  • October 15, 2008 at 7:33 am

    #885196

    My pleasure....

    You can try this...

    =IIf((Field!val1.Value/Field!val2.Value)>0,Format((Field!val1.Value/Field!val2.Value)),"#0.00000"),"0.00000")

    ..Let me knw...if it works..

    Thanks...

  • October 22, 2008 at 4:20 am

    #888011

    Hello,

    You can directly Format the TextBox as "N5", then you can get the 5 decimal places for the Number.

    Hope this helps

  • June 8, 2009 at 8:34 pm

    #1006392

    Thanks, Shilpa..

    thats better option to format the textbox to display result upto 5 decimal places

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply