Post reply

Issue with AutoRounding of decimal values on SSRS textbox

  • February 6, 2017 at 8:54 am

    #340293

    I have a database column value as 0.923074, and Want to display it as 92.30% on SSRS texbox.
    Another example value as 0.030155 and need to display as 3.01
    Currently these values are auto rounded and being displayed as 92.31% and 3.02 instead.
    Need help to prevent the autoround and display actual 2 positions after decimal.

  • February 6, 2017 at 9:07 am

    #1926895

    Edit reread, will post back an answer.

    Edit, try:
    =FLOOR(Fields!MyField.Value * 10000) / 10000

    This preserves the field as a numeric, rather than turning it into a string.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • February 6, 2017 at 9:22 am

    #1926898

    Updated. It is worth noting that the values that SSRS is giving you is correct, 0.99995000 = 1 when rounding to 4 decimal places (2 decimal places in percentage format). Thus the logic above.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • February 6, 2017 at 9:26 am

    #1926899

    Super..!! This works exactly, as needed. Thank you.

Viewing 4 posts - 1 through 3 (of 3 total)

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