Troubleshoot the reporting framework [AX 2012]


This Post contains some of the most common reporting framework issues and possible solutions.
You can find related information posted on the Microsoft Dynamics AX Product Forum at
https://community.dynamics.com/product/ax/f/33.aspx.


The report server cannot be validated
If you cannot validate the report server, do the following:
■ Click the Create button in the Reporting Servers form, which is located at Tools > Business Intelligence Tools > Reporting Servers, and make sure that a report folder and data source have been created on the report server. Click the Validate button.
■ Ensure that firewall settings are configured appropriately on the computer that is running the
report server.
■ Ensure that both the report manager and report server URLs are correct.
■ Ensure that the Microsoft Dynamics AX user has permissions on the computer that is running
the report server.

A report cannot be generated
If you are connecting to the Microsoft Dynamics AX SQL Server database and the system will not generate a report, do the following:
■ Ensure that the report server account configured in the report data source on the report
server has read permissions on the Microsoft Dynamics AX SQL Server database.
■ Ensure that firewall settings are configured appropriately on the computer on which the
database is installed.
If you are connecting to an external or custom data source, make sure that the user name and
password provided for the report server account in the data source on the report server are correct.

A chart cannot be debugged because of SharePoint sandbox issues
If you cannot debug a chart because of problems with the SharePoint sandbox, do the following:
■ Add a reference to the Microsoft.SharePoint.dll assembly to the project.
■ Establish the default web control to run in debug mode.
■ Edit the file named Default.aspx in the EP Chart project.
■ Add the ManagedContentItem property to the <dynamics:AxUserControlWebPart> element
and set the value to the name of the web control.

No comments:

Post a Comment