Formatting reports
Formatting is very useful in SSRS reports to organize all the data. If you look carefully, the amount values in the previous report output recipes are not properly aligned.
In this recipe, we will make some formatting changes and align amount values as well as text fields.
How to do it…
To set the alignment, modify the Text Align property to Left and set the Format String property to Currency.
For the AmountMST field in the table data region, modify the Format String property and set it as Currency. The revised report will appear as shown in the following screenshot:
How it works…
The format string property has a set of predefined formats that can be applied to a specific field, such as Date, Number, and so on.
Tip
If you have set up custom values on different properties and want to set the original value, then just right-click on the property window and then click on Reset. This will reset the selected property to its default value.
