Share via

does SSRS automatically round numbers

Anonymous
2022-09-13T19:06:40.523+00:00

Does anyone know if SSRs automatically round up numbers. It seams that my expression calculations are be rounded up and I do not want that.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,912 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michael Taylor 53,726 Reputation points
    2022-09-13T19:51:04.727+00:00

    SSRS will treat numbers as numbers until told otherwise. Without more context it is hard to say what is going on. For example if you're converting your number to a string then it may round/truncate depending upon how you're doing that. There is a precision limit for numbers.

    0 comments
  2. AniyaTang-MSFT 12,441 Reputation points Microsoft Vendor
    2022-09-14T02:34:46.687+00:00

    Hi @Jannette Jones
    I'm not quite sure what your expression and cell properties look like, but it could be a problem with the number of decimal places in your cell properties, you can try to adjust this a bit to avoid rounding.
    240789-1.png
    Best regards,
    Aniya

    0 comments
  3. Olaf Helper 44,216 Reputation points
    2022-09-14T06:03:23.617+00:00

    Does anyone know if SSRs automatically round up numbers

    It don't unless you defined a round/numeric format on textbox level.

    It seams that my expression calculations are be rounded up and I do not want that.

    And how does your expression look like? May a calculation with integer values causes the effect.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.