Kia
Kia

Reputation: 1

Stop SSRS from Rounding UP

I need for my raw data to display with one in SSRS.

Example: From my data from SQL database the data returns 0.228070 however in SSRS its displays 23%, but I need 22.8%

I tried using 'F2' and 'N2'

Upvotes: 0

Views: 957

Answers (2)

RET
RET

Reputation: 871

Alternatively, you can use an expression e.g.:

=FormatPercent(Fields!Fieldname.Value,1)

This will override the text box properties.

Upvotes: 0

SQL.injection
SQL.injection

Reputation: 2647

Try use the text box properties

enter image description here

Upvotes: 3

Related Questions