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:

 

Recent news

What's new in CU7 

Cumulative Update 7 for Microsoft Dynamics AX 2012 R2 recently released. It contains many new reporting features, including:

  • Windows PowerShell command for integrating multiple SSRS instances—on one computer—with AX 2012
  • New class that improves the performance of the report server
  • Ability to email reports to specific people using tokens
  • New methods for setting advanced printer properties
  • Ability to use the Compare Tool to compare report designs
  • Ability to install Management Reporter

For more information about these features, see: What’s new: Reporting.

Lifecycle Services

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

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.

 

Getting started

To learn more about how to integrate Microsoft Dynamics AX with SSRS and SSAS, review the following resources.

 

 Task

 Resources

 Plan the integration

 Install and deploy components

 Develop and customize

 Troubleshoot issues

 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. 

 Issue

 Solution

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.

 

Featured videos

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:

  • To create financial reports, you can use Management Reporter.
  • To query data and export the data to Excel, you can use the Microsoft Dynamics AX add-in for Excel.

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.

 

Related blogs

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:

  • Post your questions on the Ask the Community site and a member of the Microsoft Dynamics AX community might respond.
  • Contact your partner.
  • If enrolled in a support plan directly with Microsoft, enter a new support request with Microsoft Dynamics Technical Support.

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: