In SSRS you can set in a cell how the value should be displayed. This can cause some problems if you do not know how to change certain settings. The dot and comma can be displayed incorrectly (SSRS Decimals).
Take the number 100000,12. You would want to show it as 100.00,12. when you set the formatting to N2 (numeric 2). If you leave everything at its default in SSRS, this number is displayed as 100,000.12, the American notation. The trick is to change the language settings of the report. In SSRS, left-click outside the body. In the report properties screen, change the language setting:
Take care not to click in the body, because then you get a different properties screen.
Frequently asked questions
Why does SSRS show 100,000.12 instead of 100.000,12?
SSRS uses the American notation by default when you leave everything at its default. Change the language setting of the report to get the dot and comma right.
How do I change the language setting of an SSRS report?
Left-click outside the body of the report. Then change the language setting in the report properties screen.
Why does a click in SSRS open a different properties screen?
If you click in the body, you get the properties of the body. Click outside the body to open the report properties, where the language setting is.
What does the formatting N2 do in an SSRS cell?
N2 stands for numeric with 2 decimals. With this formatting the number 100000,12 is shown with a thousands separator and two decimals.
How do I set thousands and decimals in an SSRS cell?
Set the formatting you want in the cell, for example N2. Then set the language of the report to the right language, otherwise the display stays American.
Comments
Related blogs
SSRS Sparkline: NOW and TREND
SSRS2008R2 - Keep Header Visible While Scrolling
Create a KPI box with an image / text overlap in SSRS