One of the most notable changes we’ve made “under the hood” in this release of Microsoft Dynamics AX is that we’ve migrated the reporting framework from the X++ reporting framework to Microsoft SQL Server Reporting Services. Although the basic reporting capabilities of Microsoft Dynamics AX remain intact, and simple reports might look the same on the surface, this is a significant shift, especially for developers and partners who create or work with reports on a daily basis.
SQL Server Reporting Services offers some significant improvements over the X++ reporting framework used in Microsoft Dynamics AX 2009, both in performance and features. As a core component of the Microsoft BI platform, SQL Server Reporting Services enables us to take advantage of the Microsoft BI technology stack—including the performance and services within SQL Server—for analytics and reporting, introducing richer reporting capabilities that simply aren’t possible in X++.
Developers who are familiar with SQL Server Reporting Services or who have been using these capabilities to create reports in Microsoft Dynamics AX 2009 will be excited about the rich charting and interactivity features we’ve added to reports. Microsoft Dynamics AX 2012 gives you the ability to expand or collapse lists, drill up or down through data, and dynamically highlight values in reports. By using the new reporting framework, you can work with advanced BI functionality through SQL Server Analysis Services and view ERP information alongside online analytical processing (OLAP) data, key performance indicators (KPIs), and other statistics.
Even with all the excitement around the new reporting features, the move from X++ to SQL Server Reporting Services is a major shift and one that you’ll want to prepare for. When we talk to developers and partners about reporting in Microsoft Dynamics AX 2012, we hear the same questions over and over, along three general themes:
Finally, for those who anticipate spending a lot of time building custom reports, we provide a lot more documentation and we encourage you to read the many blogs and forums dedicated to reporting in Microsoft Dynamics AX 2012. These include detailed technical information from the product team, as well as forums where Microsoft Dynamics partners and developers share information and best practices. Below is a list of these sites:
Caption: Example of a report that retrieves data from a Microsoft Dynamics AX 2012 query. Blue text represents working hyperlinks, which open the form for a specific customer.
This is really huge achievement. Definitely, the noted Concern (2) about moving the existing base of the existing X++ reports over to SSRS is important.