Sunday, January 29, 2012

migrate AX2009 reports to AX2012 Reports

There is not any tool available that automatically publicly for the migration/conversion from Morph X++ reports into the SSRS Reports and also the upgrade engine of dynamics ax does not look after the upgrade issues in those objects such as conflicts between the two versions.
“Reports are not upgraded automatically during the upgrade process. Microsoft Dynamics AX provides hundreds of default, out-of-the-box reports that you can deploy and customize. To upgrade Morph X reports, we recommend that you customize a default report. The default reports run on SQL Server Reporting Services. Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources.
When upgrading to Microsoft Dynamics AX 2012, existing Reporting Services reports and reports based on the Morph X reporting framework are copied to the Microsoft Dynamics AX 2012system. However, they will not be upgraded” For Further Reading
There was a team sonata software that used a tool (created internally not released) to converts the X++ reports to the SSRS reports.

Basic guidelines for conversion
1.     All the logic that has been placed in fetch method of X++ report should be moved to RDP (Report data provider) class.
2.      Generated Design on X++ report will be replaced by Precision Design in SSRS reports.
3.      Report AOT query will remain the same in both approaches.
4.      X++ reports that do not contain any complex logic, can be done through query based report with Auto Design in SSRS reports.

3 comments:

  1. Hi Arsalan,

    Thanks for your post! You mention sonata software developed a tool. Do you happen to know more about this?

    Regards,

    ReplyDelete
  2. Hi Arsalan,

    So isn't there any publicly release tool for Converting X++ based reports to SSRS?

    Please let me know.

    Thanks,
    -A

    ReplyDelete
  3. how to convert ax2004 and 2009 AX report upgrade to ax2012?

    ReplyDelete