Post reply

need to truncate to 2 decimals but not rounding

  • February 25, 2014 at 2:46 pm

    #1692075

    This post is pretty old but I ran into the same issue and resolved it with an expression.

    =CDec(Left(Fields!Decimal.Value), 10)

    Then in the Text Box Properties I would set it as a Number with 2 decimal places.

    This way it would only show 2 decimal places in SSRS, but when you export it to excel it would retain the entire decimal value up to 10 decimals in my case. Adjust accordingly.:-D

Viewing post 16 (of 15 total)

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