web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SSRS on Dynamics AX 2012
Microsoft Dynamics AX (Archived)

SSRS on Dynamics AX 2012

(0) ShareShare
ReportReport
Posted on by Srikanth Alladi 190

Hello Members,

I am a newbie to Dynamics AX 2012. I need to build SSRS reports on Dynamics AX. I have seen several videos which demo the development of SSRS reports using AOT. Is this the only way to design SSRS reports on Dynamics AX 2012? Is there any other optimized way to develop SSRS reports on Dynamics AX ? Is there a meta data database which is related to Dynamics AX which gets stored on SQL Server (like reportserverdb for SSRS) ? Is this metadata db can be used for SSRS report development ? Please guide me to the right resources which will provide this kind of information.

 

 

Thanks in advance!!!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    dolee Profile Picture
    dolee 11,279 on at

    Developing SSRS report for AX2012 is different from normal SSRS report development. In AX2012-SSRS integration, you can develop query-based or RDP-based reports. I don't know of other ways of doing this and the current implementation is so far so good for me.

    The following whitepaper provides good information on developing SSRS report in AX2012:

    www.microsoft.com/.../details.aspx

  • Srikanth Alladi Profile Picture
    Srikanth Alladi 190 on at

    Thanks a lot for your reply dolee for your valuable input. Can you provide me any documentation or any videos that develop the query based SSRS reports ? Is query based SSRS reports development different to development of SSRS reports using AOT ?

  • dolee Profile Picture
    dolee 11,279 on at

    I am not sure what do you mean by "development of SSRS reports using AOT" but the whitepaper in the link I provided in my earlier post is a good start to understand how to develop SSRS reports in AX2012.

    Cheers~

  • Srikanth Alladi Profile Picture
    Srikanth Alladi 190 on at

    I really appreciate for taking your time to provide your valuable inputs.

    This link provides steps to create reports using VS 2010 and using AOT and I was referring to this link when I am saying about "development of SSRS reports using AOT"

    blogs.bojensen.eu

    Is this process same as query based development ? Which procedure (query based Vs RDP)  is the best practice to develop the SSRS reports?

    Thanks!!!!

  • dolee Profile Picture
    dolee 11,279 on at

    Yes, that is the same as what I called query-based report earlier, in that you use a query from AOT as datasource.

    For RDP basically you create a temp table with the desired schema in X++ and fill in data. Then SSRS will use this temp table as data source for the report. One advantage of using RDP is that you can manipulate the data any way you want before putting them into the temp table.

    Both ways are fully supported in Dynamics AX, just use the one that better suit the needs.

    Cheers.

  • Srikanth Alladi Profile Picture
    Srikanth Alladi 190 on at

    Thanks so much for all the inputs dolee. This has helped me a ton.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans