O'Reilly logo

Microsoft Dynamics AX 2012 R3 Reporting Cookbook by Deepak Agarwal, Chhavi Aggarwal, Kamalakannan Elangovan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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…

  1. To set the alignment, modify the Text Align property to Left and set the Format String property to Currency.
  2. 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 to do it…

How it works…

The format string property has a set of predefined formats ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required