An interesting point came to my attention today with regards to rounding in SQL Server and its features, in this case Reporting Services.
Let’s take 62.5 as our magic number, as 3 doesn’t illustrate the issue!
In SQL Server Management Studio, we can see the result of the rounding by:
SELECT ROUND(62.5,0) AS Result
Now in Reporting Services if we use the round function by:
We get the incorrect result of 62.
Using the Floor or Ceiling functions won’t achieve the desired result either.
However using the Format property, of the textbox, we can use n0 which produces the correct result of 63!