Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Develop a SSRS report including multiple tables

Posted on by 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

  • Suggested answer
    Ajit Profile Picture
    Ajit 8,755 on at
  • Jie G Profile Picture
    Jie G on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans