Dynamics Ax provides rich set of reporting capabilities for both end users and developers.
By default Dynamics Ax does not support opening the SSRS reports (created through Report Builder or without using Dynamics Ax reporting tools) in Dynamics Ax itself, instead you can only view these reports on your browser by typing the full report web address.
So, here is the workaround to open SSRS reports in Dynamics Ax created through SSRS Report Builder or any other tool.
Note: It is assumed that you have already created the SSRS report through report builder from Dynamics Ax.
Create the following Job in Dynamics Ax.
This job opens a form based on our custom display menu item.
Create a display type menu item with the following properties.
- Name: rahSRSReportView
- Label: SSRS Report Viewer
- ObjectType: Form
- Object: SRSReportView
Create an action type menu item with the following properties.
- Name: rahItemConfigSSRS
- Label: Our custom SSRS report
- ObjectType: Job
- Object: rahSRSReportView
This menu item is used to run our job with the name of SSRS report as input parameter.
Note: In parameters property only provide report name that is saved in your dynamics report folder on report manager. If you have created your own folder under Dynamics than provide report name as CustomFolder/ReportName.
Feel free to post your feedback / comments / queries.