Reply To: Microsoft Dynamics AX 2009 to Microsoft Dynamics AX 2012 upgrade

#21020

Locus IT
Participant

Hello Rashmi,

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.

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:

1. Morphx Reporting tool
2. 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 describes the options to upgrade an X++ report.

1. Define a new Reporting Services report – Visual Studio Reporting Tools for Microsoft Dynamics AX
2. 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
3. Fix the report. This is not the recommended approach as the MorphX Reporting tool is being deprecated – Morphx Reporting Tools

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.

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 describes the options for a Reporting Services report that was created or customized using the Visual Studio tools for Microsoft Dynamics AX 2009.

1. Report Upgrade Tool – Convert the Reporting Services report format to the current report format.
2. 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 describes additional details for specific kinds of Reporting Services reports.

1. 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.

2. 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).

3. 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.

4. 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.

Skip to toolbar