SQL Server Reporting Services Replace X++ Reporting Framework in Dynamics AX 2012

One of the most notable changes made "under the hood" in the Microsoft Dynamics AX 2012 is that "Microsoft migrated the reporting framework from the X++ reporting framework to SQL Server Reporting Services." Although the basic reporting capabilities of Dynamics AX remain intact, and simple reports might look the same on the surface, this's a […]

One of the most notable changes made "under the hood" in the Microsoft Dynamics AX 2012 is that "Microsoft migrated the reporting framework from the X++ reporting framework to SQL Server Reporting Services." Although the basic reporting capabilities of Dynamics AX remain intact, and simple reports might look the same on the surface, this's a significant shift, especially for developers and partners who create or work with reports on a daily basis, stated a team member who goes by the name AX PMG, at Inside Microsoft Dynamics AX.

"Reporting Services offers some significant improvements over the X++ reporting framework used in AX 2009, both in performance and features. As a core component of the Microsoft BI platform, SQL SRS 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++," explains AX PMG.

"Developers who're familiar with SQL SRS or who've been using these capabilities to create reports in AX 2009 will be excited about the rich charting and interactivity features we've added to reports. 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 SRS and view ERP information alongside online analytical processing (OLAP) data, key performance indicators (KPIs), and other statistics," the team member said.

[Source:Inside Microsoft Dynamics AX]