CODEWITHSUNDEEP
reporting-servicesreportingservices-2005
san
san

Reputation:

How to do number formatting to 1 decimal point in SSRS?

I have a SSRS report with full of number fields. I would like to have that to be displayed as in one decimal. i tried to use F1. it gives me only one decimal points in html rendering, but in excel exported version it shows 2 decimal points. How can i have just one decimal point both ecxel and html rendering.

Please comment. Thanks in advance San

Upvotes: 9

Views: 46196

Answers (3)

Katherine
Katherine

Reputation: 461

in 2012 version: FormatNumber(Fields!col.Value,2)

Upvotes: 1

Ben Garrison
Ben Garrison

Reputation: 397

Right click on the text box that contains the value you would like manipulate, select TEXT BOX PROPERTIES. Navigate to the Number tab, select Number and the # of Decimal places you want the box to allow for.

Upvotes: 0

lukehayler
lukehayler

Reputation: 628

Use N1 as your Format Property setting. N denotes Numeric formatting, the 1 denotes the number of decimal places, so N2 would give you 102.02, for example. This should carry to excel as it is rendered in html.

Alternatively, you could use the format code #,##0.00, which will give you the thousands separator and two decimal places. '#' indicates optional characters, whilst '0' indicates mandatory characters (nulls will be replaced by '0.00').

Upvotes: 19

Related Questions