Rahul Sharma

Solutions Architect - Microsoft Dynamics AX | Azure

This is a technology blog covering Microsoft Dynamics 365, Microsoft Azure, IoT, Power Apps, Power BI, .Net, SQL Server, SSRS, and related technologies. Join this blog on facebook {Rahul Sharma}, to start a discussion !!! NOTE: My employer is not responsible for the content published here.

Index | MS Dynamics AX | MS Dynamics CRM
View blog as >> Magazine | Sidebar | Flipcard | Mosaic | Snapshot | Timeslide

Open SSRS reports (designed outside Dynamics Ax) in Dynamics Ax

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.

Step 1

Create the following Job in Dynamics Ax.

This job opens a form based on our custom display menu item.

Step 2

Create a display type menu item with the following properties.
  • Name: rahSRSReportView
  • Label: SSRS Report Viewer
  • ObjectType: Form
  • Object: SRSReportView
This menu item points to a standard Dynamics Ax form.

Step 3

Create an action type menu item with the following properties.
  • Name: rahItemConfigSSRS
  • Label: Our custom SSRS report
  • ObjectType: Job
  • Object: rahSRSReportView
  • Parameters: 
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.