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…
- Go to AOT | Queries, right-click on New Query, and create a new query named
PKTCustInvoiceTrans.
- This query is used to fetch the data related to post sales orders. By using this query we can fetch related customer details and tax information corresponding to the posted sales order.
- Similarly, we will create a query based on the purchase order and name it as
PKTVendinvoiceTrans. This will help to fetch the data related to the vendor and tax information...
