26 January 2012

SSRS Insert new field error - field token is invalid

If you get this error message:

Field token Fields!MyNewField.Value is invalid. Could not find the identifier. \SSRS\Reports\Reports\

when you try to add a new field from AX to a SSRS Report.

The first thing to do is to refresh the datasets in VisualStudio.

After that you should check the Query property of the DS. If there is a fieldlist in the select statement. Just click into the property and open the "Select a Microsoft Dynamics AX Report Data Provider" Dialog. Select the required DataProvider Class and click Next. Than you'll get the possibility to select some or all fields from the tables that are provided by the DP class.

11 January 2012

Open Visual Studio with another AX configuration

If you need to start Visual Studio connected to another AOS there are two ways to do this:

  1. Create a shortcut:

    add the/AxConfig command in the Target field:
    "C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe" /AxConfig NameOfClientConfig
    "C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe" /AxConfig C:\AX2012ClientConfig\ClientConfig.axc
  2. CommandLine:
  3. you can use the commands as shown above.

10 January 2012

Dynamics AX 2012 SSRS links

05 January 2012

Test Dynamics AX 2012 SSRS Report Server Configuration

To check you're SSRS Configuration open a Microsoft Dynamics AX 2012 Management Shell as an admin and insert the following command:


If you want to run the test against a special ReportServer:

Test-AXReportServerConfiguration -Id ReportServer01

Or to check a special WSDL Port

Test-AXReportServerConfiguration -ServicesAOSName ServerName
-ServicesAOSWSDLPort 8103

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