Issue with AutoRounding of decimal values on SSRS textbox

• s-sql

  SSCommitted

  Points: 1970

  More actions

  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.

• Thom A

  SSC Guru

  Points: 99143

  More actions

  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

• Thom A

  SSC Guru

  Points: 99143

  More actions

  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

• s-sql

  SSCommitted

  Points: 1970

  More actions

  February 6, 2017 at 9:26 am

  #1926899

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