Develop a SSRS report including multiple tables

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all, I want to develop a SSRS report in AX2012 R3, I have a query which includes multiple tables and multiple joins, how do I develop report for this in AX2012

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Ajit 8,755 on at

Like (0)

Report

RE: Develop a SSRS report including multiple tables

www.tech.alirazazaidi.com/query-based-ssrs-report-from-scratch-dynamics-ax-2012-r3
Jie G on at

Like (0)

Report

RE: Develop a SSRS report including multiple tables

Hi Mnishanth97,

Do you want to create a Query-based SSRS report? If so, you may refer to the following steps.

Step 1: Create a Microsoft Dynamics AX query(You have completed this step)

Step 2: Create a new report in Visual Studio

Step 3: Apply Layout template

Step 4: Add Column sorting

Step 5: Group report data

Step 6: Filter report data

Step 7: Add a dynamic parameter

Step 8: Save and deploy the report

Step 9: View the report in Microsoft Dynamics AX

Please refer the following blog for more details: community.dynamics.com/.../query-based-ssrs-report-from-scratch-dynamics-ax-2012-r3