join two or more table and display in table

In Ax 2009 Report How to Join two or more table with condition and generate this all filed in reports…

Under AOT, create new Report and provide the query as datasource say ‘TableA’ and join with other table say ‘TableB’ & specify the relations, and then override the fetch method to provide the extra ranges (or) under datasource property you can input your ranges, finally create design with Body. For more Reports AX2009.

Hi Vishal,

What is the difference between the Report and SSRS report?

Thank you,


In AX2009 or older version there were all of MorphX Standard Reports. and in AX2012 all the reports are in SSRS. for more go through Reporting services.