Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
This page provides a list of resources to help you integrate Microsoft Dynamics AX 2012 with SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
This page contains the following sections:
What's new in CU7
Cumulative Update 7 for Microsoft Dynamics AX 2012 R2 recently released. It contains many new reporting features, including:
For more information about these features, see: What’s new: Reporting.
Microsoft Dynamics Lifecycle Services provides a cloud-based collaborative workspace that customers and partners can use to manage Microsoft Dynamics AX projects from pre-sales to implementation and operations. Based on the phase of your project and the industry you are working in, the site provides checklists and tools that help you manage the project. It also provides a dashboard so that you have a single place to get up-to-date project information.
Lifecycle Services is available to customers and partners as part of their support plans. You can access it with your CustomerSource or PartnerSource credentials. Go to Lifecycle Services.
Issue search is a search engine that you can use to quickly search for KB articles, hotfixes, and workarounds for reported issues in Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 R2. You can see which reported issues are in the process of being fixed and see notifications when a hotfix is released for a specific functional area in Microsoft Dynamics AX. You can download released hotfixes, see which code objects are affected, and see the code changes introduced by the hotfix.
Issue search is a part of Lifecycle Services. Go to Lifecycle Services.
To learn more about how to integrate Microsoft Dynamics AX with SSRS and SSAS, review the following resources:
Plan the integration
Install and deploy components
Develop and customize
View technical reference information
Common problems and solutions
The first step in troubleshooting is to use Issue search. Issue is a search engine that you can use to quickly search for KB articles, hotfixes, and workarounds for reported issues in Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 R2. You can see which reported issues are in the process of being fixed and see notifications when a hotfix is released for a specific functional area in Microsoft Dynamics AX. You can download released hotfixes, see which code objects are affected, and see the code changes introduced by the hotfix. Issue search is a part of Lifecycle Services. Go to Lifecycle Services.
The following table lists common issues encountered when integrating Microsoft Dynamics AX with SSRS and SSAS.
Reports that run for more than ten minutes time out.
See the Tips to help prevent long-running reports from timing out topic on TechNet.
I have upgraded SQL Server 2008 R2 to SQL Server 2012. When I run the Microsoft Dynamics AX Setup wizard to install the Reporting Services extensions, it recognizes both SSRS 2012 and SSRS 2008 R2.
See the AX 2012 pre-requisite checker sees both the old SQL and the upgraded SQL instance blog post.
When printing a report that has been saved as a PDF file, the printer page size does not correspond to the PDF page size.
To resolve this issue, select the Choose paper source by PDF page size check box in the Print window that is displayed when printing the report to the printer.
When printing a report to a printer, the changes I made to the page layout orientation and paper size are not honored when the report is printed.
If you are using the initial release of Microsoft Dynamics AX 2012 or Microsoft Dynamics AX 2012 Feature Pack: This is a known issue.
If you are using Microsoft Dynamics AX 2012 R2: Select the Override default settings check box. For more information, see Print or email a report.
The pagination of a report differs based on the tool used to view and print the report.
This is a known issue. For more information, see the Understanding pagination in Reporting Services topic on TechNet.
For more troubleshooting information that is regularly updated, see Troubleshooting reporting and Troubleshooting analytics on TechNet.
Check out the videos that are posted on the Dynamics AX BI Videos channel on YouTube.
Other BI tools
Although SSRS and SSAS are the primary solutions used for reporting and analysis in Microsoft Dynamics AX, other tools can be used, as well. For example:
For more information about business intelligence tools that can be used with Microsoft Dynamics AX, see Microsoft Dynamics AX 2012 R2 White Paper: Business Intelligence Capabilities and Tools and Types of reports.
The following Microsoft blogs may provide assistance to you:
Still having trouble?
If you’re still having trouble, you can get assistance in the following ways:
You can enter a support request on CustomerSource or PartnerSource by selecting Support > New Technical Support Request.
You can also contact Microsoft Dynamics Technical Support by phone using these links for country specific phone numbers:
Business Applications communities