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
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
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.
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.
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,
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156