Creating a Report using the Query in Dynamic AX (SSRS report using Query Based)

Hi,

1.       Create a query “CustQry” with datasource as CustTable.

2.       In the Visual studio Create report using the query.

a.       Create a project with Installed templates: Microsoft Dynamic AX and select Report Model at last give a name to that report.

  

b.      In the solution explorer right click on the project created add - > reports.

c.       You may find the Dataset right click on that Add Dataset.

 

In the Data source type select : Query and in the Query select the query that you created “CustQry”.

d.       Drop that dataset that you created into design.

e.      Right click on that create precision design.

f.        Customize as per your design. Then right click for preview.