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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156