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.
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.