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.


No comments: