Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Develop a SSRS report including multiple tables

(0) ShareShare
ReportReport
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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans