Report Upgrade

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

This topic provides guidance to convert X++ reports, Microsoft Visual Studio tools for Microsoft Dynamics AX reports, and troubleshooting tips for converted reports. To use the reports you created or customized in Microsoft Dynamics AX 2009, they must be converted for Microsoft Dynamics AX 2012. The upgrade readiness checklist checks the reports that will need to be upgraded for the current release. For more information, see Upgrade overview and preparation.

Converting reports

The following sections provide the suggested options to upgrade reports from Microsoft Dynamics AX 2009 to Microsoft Dynamics AX 2012. The options are provided for reports that were originally created with:

  • Morphx Reporting tool

  • Visual Studio tools for Microsoft Dynamics AX 2009

X++ reports

The X++ reporting framework is being deprecated in Microsoft Dynamics AX 2012. Reports that you created or customized using the Morphx Reporting tool will be copied to the Microsoft Dynamics AX system, but they will not be upgraded. The following table describes the options to upgrade an X++ report.

Option

Tool

Define a new Reporting Services report.

Visual Studio Reporting Tools for Microsoft Dynamics AX

For more information, see Development Tasks for Reporting.

Customize an existing production report to meet the same reporting purposes that the original X++ report served.

Visual Studio Reporting Tools for Microsoft Dynamics AX

For more information, see Integrating and Customizing Reports.

Fix the report. This is not the recommended approach as the MorphX Reporting tool is being deprecated.

Morphx Reporting Tools

For more information, see MorphX Reporting Tools.

Note

The End user settings for report print and parameter settings for X++ reports must be reset after the upgrade.

You will no longer set security explicitly on X++ report objects. For example, you previously secured a field on the report using a security key. Role and task security on report data sources like tables and fields will be enforced by X++ reports. For information, see Set up user security in Microsoft Dynamics AX.

Microsoft Visual Studio tools for Microsoft Dynamics AX reports

Due to framework changes that affect report formats and queries, you must convert reports that were created using Visual Studio tools for Microsoft Dynamics AX 2009. The following table describes the options for a Reporting Services report that was created or customized using the Visual Studio tools for Microsoft Dynamics AX 2009.

Tool

Task

Report Upgrade Tool

Convert the Reporting Services report format to the current report format. For more information, see Report Project Upgrade.

Visual Studio tools for Microsoft Dynamics AX

Define a new report.

Or

Customize an existing production report to meet the same reporting purposes.

Troubleshooting converted reports

After an Microsoft Dynamics AX 2009 report is converted, there may be additional troubleshooting steps required in Visual Studio tools for Microsoft Dynamics AX. The following table describes additional details for specific kinds of Reporting Services reports.

Report issue

How to resolve

Report data source is SQL and you are receiving the error:

An SqlParameter with ParameterName ‘AX_CompanyName’ is not contained by this SqlParameterCollection.

Refresh the dataset for the report to clear out legacy parameters. In Model Editor, right-click the dataset for the report and then click Refresh.

Report data source is SQL and you are receiving the error:

The ‘AX_CompanyName’ parameter is missing a value.

Remove the AX_CompanyName parameter. To do this, in Model Editor, select the AX_CompanyName parameter. In the Properties window, set the Default Value to =Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GetUserComany(Nothing).

Report has data methods and you receive an error that the application requires Full Trust permissions to run correctly.

Data methods must run with the FullTrust named permission set. For more information, see Code Access Security.

The report parameter values no longer display in the report header.

The RenderParameter property is intended to debug report parameter values. It displays the parameter values in the header of the report. The default value in Microsoft Dynamics AX 2009 for the RenderParameter property was True. In Microsoft Dynamics AX 2012, the default value is False. During upgrade, the value is not explicitly set.

To show the parameter values in the report header, in Model Editor, select the auto design for the report and set the RenderParameter property to True.

See also

Upgrade overview and preparation

Report Project Upgrade