SQL Server Report Builder Number Formatting

Question

I am creating Reports in SQL Server Report builder.

When I set format of any number fields, in design it is displaying sample value.

For e.g. If I set format 0.00 to one numeric field, it started to display 12345.00

I have 10-12 fields in design, it caused very much confusion.

Is there any solution to change this?

When I open report in Visual Studio, it doesn't display like that.

Check Following screenshots:

In Report Builder:

In Visual Studio:

Answer 1

From what you described looks like you have an issue with the regional settings number format.

In your development environment, the decimal values are retrieved correctly, so you got 123.45 instead of 12345.00

In your target environment, the format of the decimal values is different, for example is 123,45 (comma instead of dot) so you get 12345.00

Answer 2

Finally, I got solution:

There is option in toolbar.