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

Creating reports by fetching the data using complex queries

In this recipe, we will develop an SSRS report in Dynamics AX R3 using complex queries. This will help to fetch the complex data and show it in the report. In this recipe, we will create three queries and get the data from these queries in a single SSRS report.

Getting ready

In this recipe, we will create three queries which will be further used in the next recipe for fetching data. These three queries will be based on the sales order, purchase order, and transfer order.

How to do it…

  1. Go to AOT | Queries, right-click on New Query, and create a new query named PKTCustInvoiceTrans.
    How to do it…
  2. This query ...

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