Report Project Upgrade [AX 2012]

Updated: February 1, 2012

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

The report upgrade tool is a command line tool that helps you prepare Microsoft Dynamics AX 2009 SQL Server Reporting Services report libraries for the Microsoft Dynamics AX 2012 AOT environment. This is a required step for Microsoft Dynamics AX 2009Reporting Services reports that you want to upgrade to Microsoft Dynamics AX 2012 Reporting Services reports because metadata is now accessed in the AOT nodes instead of .moxl files.

The report upgrade tool locates the Microsoft Dynamics AX 2009 report projects for the location you specify. The following list describes the tasks that the report upgrade tool performs for each report project:

  1. Creates a Dynamics AX Model Project with the same name. The project is created in the AOT in Visual Studio Projects > Dynamics AX Model Projects. Nested business logic is saved but it is not nested.

  2. Identifies the concepts for each Microsoft Dynamics AX model file and creates the appropriate node under the SSRS Reports node in the AOT. The SSRS Reports node is used to store metadata for the top level element and sub-elements. The SSRS Reports node that is created does not contain project files.

  3. Displays the completion status of the upgrade and any errors that occurred.

Using the Report Upgrade Tool

The default install location of the report upgrade tool is C:\Program Files\Microsoft Dynamics AX\60\tools. The syntax for the tool is as follows:

UpgradeReports [command] –t [target directory] <options>

ImportantImportant

The files in the target directory will be deleted.

You can access Help at the command line from the upgrade tool location, by running UpgradeReports -?.

The following table describes the report upgrade tool parameters:

Command

Description

-p

The project to upgrade. The extension of the project is .dynamicsproj.

-d

The directory that contains projects to upgrade. Subdirectory projects are also upgraded.

-l

The report library from the AOT to upgrade. The library is first extracted to a temporary location.

-list

A list of the report libraries from the AOT to upgrade. Each report library should be listed on a separate line.

-t

The target directory where the upgraded project is created.

The following table describes the report upgrade tool options:

Option

Description

-stop

Stop the upgrade when there is an error. By default, the upgrade continues to run if you do not use the –stop option.

-overwritenodes

Overwrite the nodes in the AOT. By default, the nodes are not overwritten if you do not use the –overwritenodes option.

-createlabels

Create labels in Microsoft Dynamics AX for strings that are in the .resx files. By default, labels are not created unless you use the –createlabels option.

-savetoaod

Save the project to a report library in Microsoft Dynamics AX.

Examples

The following table provides examples and descriptions of command line uses of the report upgrade tool:

Example

Description

UpgradeReports -l CRMReports -t d:\temp

Upgrades the report from the CRMReports library in the AOT.

UpgradeReports -p reportsDir\CRMReports.dynamicsproj -t d:\temp

Upgrades the CRMReports project from disk.

UpgradeReports -d reportsDir -t d:\temp

Upgrades all reports in the reportsDir directory and its subdirectories.

UpgradeReports -list d:\reports.txt -t d:\temp

Upgrades the libraries that are specified in the reports.txt file. The contents of the file d:\reports.txt are the following:

AssetAcquisitionReport

AssetAdditionReport

AssetBalanceReportColumnsReport

Community Additions

ADD
Show: