sqlreporting-servicesreportbuilderreport-builder2.0

SQL Server Report Builder Number Formatting


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:

Report Builder

In Visual Studio:

VisualStudio


Solution

  • Finally, I got solution:

    There is option in toolbar.

    Place Holder