Reporting in Microsoft Dynamics AX

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Microsoft SQL Server Reporting Services (SSRS) is the primary reporting platform for Microsoft Dynamics AX. The default, predefined reports that are provided with Microsoft Dynamics AX run on the Reporting Services platform.

This topic guides you through the process of installing, deploying, and using these reports. This topic also provides information about how to create custom reports.

Get started Install and deploy Configure Extend Use Troubleshoot View technical reference

Microsoft Dynamics AX Business Intelligence (blog) Microsoft Dynamics AX BI videos channel (videos) Analytics in Microsoft Dynamics AX (articles)

The following table lists tasks that you can complete to learn more about Reporting Services and how it integrates with Microsoft Dynamics AX.

Task	Details	More information
Learn about the new reporting features of Microsoft Dynamics AX	Several features have been added to Microsoft Dynamics AX 2012 releases to help you install the Reporting Services extensions and deploy reports. For example: In cumulative update 7 for Microsoft Dynamics AX 2012 R2: A Windows PowerShell command is available in cumulative update 7 for Microsoft Dynamics AX 2012 R2 that automates the process of integrating multiple Reporting Services instances with Microsoft Dynamics AX. In Microsoft Dynamics AX 2012 R2: Support for report servers that run in SharePoint integrated mode was added.	What's new: Reporting
Become familiar with Reporting Services and plan your implementation	Reporting Services is the primary reporting platform for Microsoft Dynamics AX. The default, predefined reports that are provided with Microsoft Dynamics AX run on the Reporting Services platform.	Reporting architecture Overview of Reporting Services Planning for reporting in Microsoft Dynamics AX
Determine what other reporting tools you may want to use	Although Reporting Services is the primary reporting platform for Microsoft Dynamics AX, there are other reporting tools that you should use, as well. For example, we recommend that you use Management Reporter to create financial statements.	Types of reports Business Intelligence Capabilities and Tools white paper Management Reporter for Microsoft Dynamics ERP

The following sections explain how to install and deploy reports and how to upgrade reports from Microsoft Dynamics AX 2009 to Microsoft Dynamics AX 2012.

Install and deploy reports

Complete the tasks in the following table to integrate Microsoft Dynamics AX and Reporting Services and to deploy the reports that are included with Microsoft Dynamics AX.

Task	Details	More information
Verify permissions	To install the Reporting Services extensions, you must run the Microsoft Dynamics AX Setup wizard. Verify that you have the required permissions to run the wizard.	Verify that you have the required permissions for installation
Assign system service accounts to the appropriate Active Directory groups	Identify which accounts are used for the following purposes: The account used to run the Microsoft Dynamics AX Application Object Server (AOS) The account used as the Business Connector proxy Assign the accounts listed above to the following Active Directory groups on the domain server: Windows Authorization Access group Pre-Windows 2000 Compatibility Access group
Install prerequisites	On the computer where Reporting Services is installed, or where you plan to install Reporting Services, run the prerequisite validation utility to verify that system requirements have been met.	Check prerequisites System requirements
Configure Reporting Services	Configure Reporting Services for use with Microsoft Dynamics AX. The steps you must follow vary depending on whether you installed Reporting Services in native mode or SharePoint integrated mode.	Before you install the Reporting Services extensions
Install the Reporting Services extensions	Run the Microsoft Dynamics AX Setup wizard on your report server to install the Reporting Services extensions.	Install the Reporting Services extensions
Deploy reports	Note If you are using Microsoft Dynamics AX 2012 R2—and—Reporting Services is running in SharePoint integrated mode, then you must create a document library in SharePoint to store your reports. Complete this procedure before you deploy the default reports that are included with Microsoft Dynamics AX. Microsoft Dynamics AX includes many default reports that you must deploy. If you did not deploy the reports when you installed the Reporting Services extensions, you can deploy them by using Windows PowerShell.	Create a document library to store reports Deploy the default reports
Deploy language-specific versions of a report	Typically, when you deploy a report, one version of the report is deployed. This version can then be rendered automatically in every language that is supported by Microsoft Dynamics AX. However, you can configure Microsoft Dynamics AX so that language-specific versions of a report are deployed. A language-specific version of a report is rendered more quickly.	Deploy language-specific versions of a report
Integrate additional instances of Reporting Services—that run on the same computer—with Microsoft Dynamics AX	You can install multiple instances of Reporting Services on the same computer. In this kind of deployment environment, each instance of Reporting Services is connected to an independent Microsoft Dynamics AX installation. You may want to install multiple instances of Reporting Services on the same computer for the following reasons: To support development and production installations of Microsoft Dynamics AX To support multiple production installations of Microsoft Dynamics AX	Install multiple instances of Reporting Services on the same computer (for use with Microsoft Dynamics AX)

Upgrade reports

The following table provides information about how to upgrade reports in Microsoft Dynamics AX.

Task	Details	More information
Upgrade reports	When you upgrade from Microsoft Dynamics AX 2009, existing reports are copied to the AX 2012 system, but they are not upgraded. AX 2012 provides hundreds of default, predefined reports that you can deploy and customize. We recommend that you use these reports as templates and customize them to meet your requirements.	Report Upgrade Report Project Upgrade Guidance when Upgrading Reports Mapping Microsoft Dynamics AX 2009 Reports to the Microsoft Dynamics AX 2012 Version Deprecated Microsoft Dynamics AX 2009 Reports in Microsoft Dynamics AX 2012

After you have deployed the reports, complete the following tasks to make them available to users.

Task	Details	More information
Grant users access to reports	Grant users access to reports. The steps you must follow vary depending on whether you installed Reporting Services in native mode or SharePoint integrated mode.	Grant users access to reports
Prepare the report server for use each day	Reporting Services periodically restarts, and each restart clears the Reporting Services cache. After the cache has been cleared, it may take some time for the next report that is run to display. To minimize the effect of Reporting Services restarts, a new class that is named SRSReportServerWarmup is included with cumulative update 7 for Microsoft Dynamics AX 2012 R2. When the SRSReportServerWarmup class runs, it prepares the report server for use.	Run the SRSReportServerWarmup class

You can use Microsoft Visual Studio to customize existing reports, develop new reports, and integrate those reports with Microsoft Dynamics AX.

Task	Details	More information
Customize a report which is defined in a model project included with Microsoft Dynamics AX.	Model projects in Microsoft Dynamics AX adhere to layered development in the MorphX development environment. This allows model projects to be customized, upgraded, and patched using the built-in layering support. You can see those changes applied in Microsoft Dynamics AX.	Walkthrough: Customizing Existing Microsoft Dynamics AX Reports
Create a new auto-design reporting project and add it to the AOT.	To retrieve data for an auto-design reporting project you will use a query that is defined in the AOT within the Microsoft Dynamics AX development environment. Once the project is created, you can modify the look of the report using layout and style templates and add interactive features like grouping, sort order, and document maps.	Walkthrough: Creating an Auto Design Report
Integrate a report into Microsoft Dynamics AX.	Once you have created a reporting project, you integrate the report into Microsoft Dynamics AX. For example, after the report is in Microsoft Dynamics AX, you can create an output menu item for the report and display the report on a menu within the application.	Walkthrough: Integrating New Reports into Microsoft Dynamics AX
Create a drillthrough repor.t	A drillthrough report is a report that a user opens by clicking a linked item in another report. It allows users to drill through to additional data.	Walkthrough: Creating a Drillthrough Report
Create a report from an external data source.	A data source is a facility for accessing data. You can use the predefined Dynamics AX data source, which connects to the Microsoft Dynamics AX application database. Or, you can define an external data source to retrieve data from a different location. In your report model, you will define an external data source that specifies the connection information for the database so that you can retrieve data from that database to display in your report.	Walkthrough: Creating a Report from an External Data Source
Use a report data provider (RDP) class with business logic to process data and then display the outcome of the business logic on a report.	An RDP class is an X++ class that is used to access and process data for a Reporting Services report. The options for a data source type for a Microsoft Dynamics AX report are query, business logic, and RDP. An RDP class is an appropriate data source type when you cannot query directly for the data you want to render on a report, or the data to be processed and displayed is from Microsoft Dynamics AX.	Walkthrough: Creating a Report Bound to a Report Data Provider Class (X++ Business Logic)
Add parameters to a report to allow users to filter the data that displays in the report.	For example, you can add a parameter and a filter that uses the parameter to allow users to select a customer for which to display data. Then, you can add parameters that will be used to determine whether to display the phone and fax numbers for the customers in the report.	Walkthrough: Creating a Report with Parameters
Create a report to display customer transaction data in a matrix data region.	A matrix data region displays data in a two-dimensional grid of columns and rows that intersect at specific data points. When defining a matrix data region, you can specify column and row groupings. The data that appears in the detail cells are aggregates based on the intersections of columns and rows.	Walkthrough: Creating a Matrix Report
Create a report to display customer transaction data in a column chart.	A chart provides a graphical representation of data. Displaying data in a chart makes it easy for users to see comparisons, patterns, and trends in the data.	Walkthrough: Using AX Enum Provider in a Column Chart Report
Create a precision design for a report using SQL Report Designer.	You can create a precision design report to display the data returned by the queries that you created in Microsoft Dynamics AX. To do this, you will first define datasets for the report. Then, you will configure the parameters that are created for the datasets. Finally, you will use SQL Report Designer to define the report layout.	Walkthrough: Referencing a Report Parameter from Multiple Datasets in a Precision Design Report
Create a report that is bound to date effective data.	Date effective data is valid time state data for which changes must be tracked at different points in time. On a table in the AOT, you can set the ValidTimeStateFieldType property to make it a valid time state table. Setting this property causes the system to automatically add the ValidFrom and ValidTo columns which track a date range for each row. Reports that are bound to valid time state data will provide a parameter for the date range or a specific date on the parameter form when you run the report.	Walkthrough: Creating a Report Bound to Date Effective Data
Create a report that uses dimensions	Dimensions are additional classifications defined in a table for financial, product, and cost attributes. You will can create a report that displays a dimension string, dimension attributes, and a report parameter based on a dimension. When you run the report, you can filter the report by the dimension.	Walkthrough: Creating a Report Bound to a Dimension Data Source

The following sections provide information about how business users, such as CFOs and accounting managers, can create and use reports.

Use the Reporting Services reports that are provided with Microsoft Dynamics AX

End users in your organization can use the information in the following table to work with the default reports that are provided with Microsoft Dynamics AX.

Task	Details	More information
Print or email a report	Microsoft Dynamics AX includes hundreds of preconfigured reports that you can use to view and analyze business data. The linked topic explains how to print or email a report.	Print or email a report
Print or email a report on a recurring basis	Microsoft Dynamics AX includes hundreds of preconfigured reports that you can use to view and analyze business data. The linked topic explains how to configure Microsoft Dynamics AX to automatically print a report for you on a recurring basis. For example, Microsoft Dynamics AX can send a specific report to you and your team members every Monday morning by email.	Print or email a report on a recurring basis
Print or email a report during off-peak hours	Occasionally, you may have to print an especially long report, such as a report that contains hundreds of rows of data. In this case, it may be best to print the report during off-peak hours, when few users are logged on to Microsoft Dynamics AX. The linked topic explains how to schedule a report to be printed during off-peak hours.	Print or email a report during off-peak hours
Print a report from the archive	If you saved a report to the print archive, you can use the linked topic to print the report from the archive.	Print a report from the archive
Filter the data on a report	By filtering the data that is displayed on a report, you can view only the data that is important to you. The linked topic shows how to filter the data on the Customers report. You can modify this procedure to filter the data on the report that you are working with.	Filter the data on a report
Sort the data on a report	You can sort the data that is displayed on a report. The linked topic shows how to sort the data on the Customers report. You can modify this procedure to sort the data on the report that you are working with.	Sort the data on a report

Create a custom report

End users in your organization can use the information in the following table to create the custom reports they need.

Task	Details	More information
Create a report by using the Microsoft Dynamics AX auto-report wizard	Auto-reports are preconfigured reports that you can generate by clicking File > Print > Print in a Microsoft Dynamics AX form. You can quickly generate an auto-report for use once, or you can create and save a custom auto-report that can be reused later.	Create a report by using the Microsoft Dynamics AX auto-report wizard
Create a report by using Excel	You can use Microsoft Excel to create a custom report that uses a Microsoft SQL Server Analysis Services cube as a data source.	Create a report by using the Excel data connection wizard to connect to a cube
Create a report by using SQL Server Report Builder	You can use Report Builder, which is a component of Reporting Services, to create a custom report that uses an analysis cube as a data source.	Create a report by using SQL Server Report Builder to connect to a cube
Create a report by using Power View	Power View is a tool that you can use to create highly-interactive, ad-hoc reports that use analysis cubes as a data source.	Create a report by using Power View to connect to a cube

The following topics explain how to troubleshoot issues that you may encounter when you work with reports.

Task	Details	More information
Troubleshoot issues with Reporting Services reports	Find possible solutions to common issues that may occur when you install, deploy, or use Reporting Services reports.	Troubleshoot issues when running the Setup wizard to install the Reporting Services extensions Troubleshooting Report Definition Issues Troubleshoot Report Deployment Issues Troubleshoot Issues with Printing and Emailing Reports How to: Configure the Debugger to Debug a Report Data Provider Class Tips to help prevent long-running reports from timing out SSRS report tips to adjust alignment for pre-formatted print stock (i.e. 1099-MISC form) Troubleshooting System Services

The following table provides links to technical reference information for reports.

Task	Details	More information
View the Reporting Services report catalog	The Report Catalog for Microsoft Dynamics AX 2012 describes the Reporting Services reports that are provided with Microsoft Dynamics AX 2012.	Report catalog for Microsoft Dynamics AX