sqlreporting-servicesreport-builder2.0

SQL Server Report Builder Field 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:

enter image description here

In Visual Studio:

enter image description here

Solution

  • Finally, I got solution:

    There is option in toolbar

    enter image description here