Do you have multiple instances of SQL Server Reporting Services that run on the same computer? Do you want to integrate those instances with Microsoft Dynamics AX? If so, a Windows PowerShell command is now available with cumulative update 7 for Microsoft Dynamics AX 2012 R2 that makes the integration process a whole lot easier!
For example, assume that you have a report server that hosts three Reporting Services instances. To integrate these instances with Microsoft Dynamics AX, follow these steps:
- Integrate the first Reporting Services instance with Microsoft Dynamics AX. To do this, run the Microsoft Dynamics AX setup wizard to install the reporting extensions, and then deploy the reports that are included with Microsoft Dynamics AX. For more information, see Checklist: Install the Reporting Services extensions and deploy reports.
- Integrate the second Reporting Services instance with Microsoft Dynamics AX by running the Install-AXReportInstanceExtensions Windows PowerShell command.
- Integrate the third Reporting Services instance with Microsoft Dynamics AX by running the Install-AXReportInstanceExtensions command.
The following diagram summarizes this process.
For information about how to run the Install-AXReportInstanceExtensions command, see Install multiple instances of Reporting Services on the same computer (for use with Microsoft Dynamics AX).