04 January 2012

Deploy Dynamics AX 2012 default SSRS reports

If you get the following error message while trying to open a standard report in Dynamics AX 2012:

Error while setting server report parameters. Error message: Das /DynamicsAX/StaticReports/en-US/SalesInvoice.Report-Element wurde nicht gefunden. (rsItemNotFound)

The first thing to check are the reportServer Settings in AX: System administration -> Setup -> Business Inteligence -> Reporting Services -> Report Server

Click Validate Settings to find out if the parameters are set correctly. If this succeeds Ax is set up correct and you'll only have to deploy the AX Reports to the SSRS Server. Therefor you need to open an instance of the Microsoft Dynamics AX 2012 Management Shell (run as Administrator).  
In the PowerShell window you can use the following command:

Publish-AXReport -ReportName * 

or to publish just one Report

Publish-AXReport -ReportName NameOfTheReport 
when having problems with user permissions one solution could be the parameter -skipReportServerAdminCheck.
Microsoft said: Actually the code inside axutil is trying to make a check for the user’s permissions – and it is the check itself that needs higher permissions (it’s looking into Active Directory). So the problem is that the user does not have enough rights to make the check in Active Directory, but they would have enough to actually deploy reports
Publish-AXReport -ReportName NameOfTheReport -skipReportServerAdminCheck

If you want to deploy Reports from the AOT it's recommended to start the AX as an Administrator
Post a Comment