AX 2012 – New Reporting Functionality
In Dynamics AX 2012 (Formally known as Axapta), extensive changes have been made in the area of reporting. SQL Server Reporting Services (SSRS) is the primary platform for reporting in the new version. The Report Development Environment in AX is easier to work with as it is now fully integrated with Visual Studio 2010 and utilizes extended SQL Server tools. Microsoft is working on the move to SSRS and at last count, 850 out of the 1245 out-of-the-box reports have been converted to the new platform.
Dynamics AX 2012 – What’s New
In Microsoft Dynamics AX 2012 (DAX 2012_, there is a new concept of a Report Data Provider (RDP) framework which handles all the processing of data fetched for the report. The RDP framework aims to improve on performance by calculating and storing all the displayable data in a temporary table. This way, the report can directly render the output quicker than before. SSRS also calls the AX Application Object Server to run the report leading to speedier reports. A new powerful feature available in DAX 2012 is the Drill-through functionality. Using parameters that enable drill-through actions, reports can now be linked to each other. Users can conceivably drill down on the data on the report to the most detailed level. Using the Interactive Sort property on report fields, users can sort the data by any such columns in their report before actually sending it to the printer. SSRS is now more EDT-aware. EDT is the library or definition of fields used in Dynamics AX. In previous versions, some columns did not display fully or in the correct format without additional tweaking of the column design when creating a report. Now, properties such as Display Width, Date/time and Numeric formatting are automatically set.
Microsoft Dynamics AX 2012 Reporting – Upgrading and Challenges
All the X++ reports currently available in AX will be discontinued. There is no direct upgrade path from the current X++ reports to the SSRS reporting platform. All custom reports will have to be recreated in the new environment. This will obviously make upgrades more complex and expensive, but in the long run, will result in a much more flexible, standard and powerful reporting environment.
If you need help with upgrading or just want advice or service, email us at firstname.lastname@example.org
by Charan Bhamidi
Edited by Mark Chinsky