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

Financial dimensions in query reports

As inventory dimensions influence trade and logistics reports, so do financial dimensions influence financial reports. In this recipe, we will see extensively how financial dimensions can be used in the design of a report, in the report dialog, and more. There are two recipes discussed here: one using financial dimensions in a simple query report and the other in an RDP report.

The following recipe will discuss how to use dimensions in a simple query-based report.

How to do it…

  1. Create a new query and add the LedgerJournalTrans table to it. Set the Dynamic field property to Yes.
  2. In Visual Studio, create a new project. Create a new report and add a dataset.
  3. In the Query properties, click the browse button to open ...

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