Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

How can I add ssrs report to AOT ?

Posted on by 110

I have created ssrs report using Microsoft business intelligence , the data source is AX

the report extension now is RDL , How can i add this report and display it in the SSRS part in the AOT ?!!

*This post is locked for comments

  • Suggested answer
    Brandon Ahmad Profile Picture
    Brandon Ahmad 2,465 User Group Leader on at
    RE: How can I add ssrs report to AOT ?

    That's not an AX Reporting/Model SSRS project.  That is a regular SSRS project without the proprietary AX hookins.  Therefore, you can not directly deploy it via AX mechanisms.  

    But there are two solutions:

    1. Redo the report as an SSRS Model Project directly connected to the AOT and within the AX framework

    2. Deploy your non-proprietary, SSRS report to the report server via visual studio.  Then,  Simply create a menu item and a class and call the URL which renders the report.  The report will then pop up from the AX graphical user interface.  Dick Wenning published an excellent post on how to do this:

    community.dynamics.com/.../call-non-ax-reports-on-ssrs-in-ax-2012.aspx

    And I plan to publish my own method for doing this after I get through a few other blog posts first, but Dick's process will get you there.

  • Suggested answer
    Khaled Ahmed Profile Picture
    Khaled Ahmed 2,467 on at
    RE: How can I add ssrs report to AOT ?

    Hi  YASMINE SHAMS;

    First you need to created in Visual studio in ax application View   , then you can save it in AOT then deploy it to user in ax , after create menu item.

    best regards.

  • Yasmine Shams Profile Picture
    Yasmine Shams 110 on at
    RE: How can I add ssrs report to AOT ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How can I add ssrs report to AOT ?

    Hey Yasmine,

    If your Visual Studio is connected to the AOT. You should press the 'Add <project> to AOT' when right clicking the Project node in your Solution Explorer.

    When you did that, you can Deploy the Project by right clicking it again and press 'Deploy'

    Kr,

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans