SSRS rounds to whole numbers, but includes 2 decimal places
I have some SQL, of which the part in question is:
sum(Minutes)/60.0 Hrs
In SQL Server Management Studio, my database returns:
14.500000
In SSRS, my report displays:
14.00
My RDL's cell that displays this value has this definition:
=Fields!Hrs.Value
The cell's textbox properties have been defined as a Number, no checkboxes
selected, 2 decimal points.
So, the question is, why is my report only outputting 14.00 rather than
14.50 and how can I fix it?
No comments:
Post a Comment