AX 2012 SSRS Report Development - Part 1

 1.  SSRS Definition, Installation and Configuration:

SQL Server Reporting Services is the primary reporting platform for Microsoft Dynamics AX. Reporting Services is a server-based reporting platform that includes a complete set of tools to create, manage, and deliver reports, and APIs that enable you to integrate or extend data and report processing in custom applications. Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components. Before you start the developing SSRS report for MS Dynamics AX, you need to install BI components and Visual Studio tools from MS Dynamics AX setup. The setup form is shown below with BI Components and Visual Studio tools options checked:

After installing BI Components and Visual Studio tools, you are ready to start working on SSRS reports for MS Dynamics AX. To verify that the BI Components installed successfully and report servers are correctly configured in MS Dynamics AX, Go to Tools -> BI tools -> BI reports servers. Configuration form is shown below:

Verify with Validate settings button that the values are filled in and server name is the name of your machine.

2. Deploy SSRS Reports:

After Installation and configuration the site will be created on SharePoint sites. We need to deploy all the reports in to the Web site, then only we can run the report.

Ø  Deploy one report in Ax 2012

In the AOT, expand the SSRS Reports node, expand the Reports node, right-click the report, and then click Deploy Element.

Ø  Deploy in one Report in Visual Studio

Solution Explorer, right-click the reporting project that contains the reports that you want to deploy, and then click Deploy.

For that we can deploy all reports at once using AX 2012 Powershell.

Before you can deploy the reports by using Windows PowerShell, you must complete the following tasks:

·         Verify that Windows PowerShell 2.0 is installed on the computer that you are using.

·         Verify that your Windows domain account is a member of the Administrators group on the server that is running Reporting Services.

• Open Windows PowerShell as an administrator by following these steps:
• Click Start > Administrative Tools.
• Right-click the Microsoft Dynamics AX 2012 Management Shell option.
• Click Run as administrator.

            Publish-AXReport –ReportName SalesInvoice    //used for one report

            Publish-AXReport –ReportName *                     //Used for all reports

Error:

The network path was not found.

 If User Account Control (UAC) is enabled on the machine, close the application, right-click the application, and then click Run as administrator.

The error-message suggests the issue to be caused by not having administrative permission when deploying the reports. But that was not the case.
After opening a support case at Microsoft Dynamics AX support it took us over two weeks to find the real issue:

start the Remote registry Services

 Start -> Administrative Tools -> Services -> Remote registry.

Then deploy the Report

  

Warm Regards, 

Mahesh Amundla