Deploy SSRS reports for the new Reporting Services instance

Deploy SSRS reports for the new Reporting Services instance :

Open Windows PowerShell and view a list of reports

Complete the following procedure to open Windows PowerShell and view a list of the reports that are included with Microsoft Dynamics AX.

1.      Open Windows PowerShell as an administrator by following these steps.

1.      Click Start > Administrative Tools.

2.      Right-click the Microsoft Dynamics AX 2012 Management Shell option.

3.      Click Run as administrator.

2.      Retrieve a list of the reports that are included with Microsoft Dynamics AX, and store the list in a local variable by entering the following command:

Windows PowerShell

$reports = Get-AXReport -ReportName *

For more information about the Get-AXReport command, see Get-AXReport.

3.      View the list of reports by entering the following command:

Windows PowerShell

$reports

Filter the list of reports

In the previous procedure, you displayed a list of all the reports that are included with Microsoft Dynamics AX. To modify and filter the list, you can use the following commands.

·         To modify the list so that only the Name and ChangedDate fields are displayed, enter the following command:

Windows PowerShell

$reports | Select-Object Name,ChangedDate

·         To filter the list so that only specific reports are listed, enter keywords or report names. For example, to filter the list so that only reports that contain the word CustTrans are listed, enter the following command:

Windows PowerShell

$reports | Select-Object Name,ChangedDate | Where { $_.Name -like "CustTrans*" }

Deploy the reports

After you have retrieved a list of reports, you can deploy the reports. The Publish-AXReport command is used to deploy the reports. The following examples show how to use this command. For more information, see Publish-AXReport.

Note

In the following examples, SSRSConfigID refers to a configuration ID that was defined in Microsoft Dynamics AX. To view these configuration IDs, open Microsoft Dynamics AX and then open the Report servers form. (Click System administration > Setup > Business intelligence > Reporting Services > Report servers.) To deploy reports to the new Reporting Services instance, enter the configuration ID that is associated with that instance.

·         To deploy a specific report, enter the name of the report. For example, to deploy the CustTransList report, enter the following command:

Windows PowerShell

Publish-AXReport –Id SSRSConfigID -ReportName CustTransList

·         To deploy two or more specific reports, enter the names of the reports. For example, to deploy the CustTransList and CustTransOpenPerDate reports, enter the following command:

Windows PowerShell

Publish-AXReport –Id SSRSConfigID -ReportName CustTransList, CustTransOpenPerDate

·         To deploy all reports, enter the following command:

Windows PowerShell

Publish-AXReport –Id SSRSConfigID –ReportName *