What's new: Reporting

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 is now 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 article describes the new reporting features of Microsoft Dynamics AX.

What's new

New features in cumulative update 7 for Microsoft Dynamics AX 2012 R2

New features in Microsoft Dynamics AX 2012 R2

New features in Microsoft Dynamics AX 2012

Resources

New, Changed, and Deprecated Features for AX 2012 (articles)

What's new: Analytics (article)

New features in cumulative update 7 for Microsoft Dynamics AX 2012 R2

The following reporting features have been added in cumulative update 7.

Windows PowerShell command for integrating multiple Reporting Services instances with Microsoft Dynamics AX

If multiple instances of Reporting Services run on the same computer, and you want to integrate those instances with Microsoft Dynamics AX, a Windows PowerShell command is now available that automates the process.

For example, assume that you have a report server that hosts three Reporting Services instances. To integrate these instances with Microsoft Dynamics AX, you must follow these steps:

  1. Integrate the first Reporting Services instance with Microsoft Dynamics AX. To do this, run the Microsoft Dynamics AX setup wizard to install the reporting extensions, and then deploy the reports that are included with Microsoft Dynamics AX. For more information, see Checklist: Install the Reporting Services extensions and deploy reports.

  2. Integrate the second Reporting Services instance with Microsoft Dynamics AX by running the Install-AXReportInstanceExtensions Windows PowerShell command.

  3. Integrate the third Reporting Services instance with Microsoft Dynamics AX by running the Install-AXReportInstanceExtensions command.

The following diagram summarizes this process.

Multiple SSRS instances on one server

For information about how to run the Install-AXReportInstanceExtensions command, see Install multiple instances of Reporting Services on the same computer (for use with Microsoft Dynamics AX).

New class that improves the performance of the report server

Microsoft SQL Server 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 by performing the following tasks:

  1. Loads Microsoft Dynamics AX business logic assemblies

  2. Connects to Reporting Services

  3. Runs a sample report that is named SRSReportServerWarmup

As a best practice, you should schedule the batch job that runs the SRSReportServerWarmup class to run immediately after Reporting Services restarts. For more information about how to configure the batch job, see Run the SRSReportServerWarmup class.

Ability to email reports to specific people by using tokens

In cumulative update 7, you can email reports to specific people by using tokens. When you use this feature, you don’t have to enter the email addresses of all recipients. Instead, you just enter a token. The token instructs Microsoft Dynamics AX to retrieve the appropriate email addresses from worker, customer, or vendor records.

You email reports to the following people:

  • Workers in your organization who have a specific job title

    You can use the @<Job Title>@ token to email reports to workers in your organization who have a specific job title. For example, suppose that you want to email the Recruitment Projects report to all workers in your organization who have the job title of Staffing Specialist. In this scenario, you would enter the @Staffing Specialist@ token in the To field when you email the report.

    The @Staffing Specialist@ token instructs Microsoft Dynamics AX to perform the following tasks:

    1. Retrieve a list of all workers who have the Staffing Specialist job title.

    2. Retrieve the primary email address for each worker who is identified in step 1.

    3. Email the Recruitment Projects report to each worker who is identified in step 1 by using the email addresses that are retrieved in step 2.

  • Customers and vendors who have a specific purpose

    You can email reports to customers and vendors who have a specific purpose by using the @<Purpose>@ token. In Microsoft Dynamics AX, contact information (such as email addresses) for customers and vendors has a purpose associated with it. For example, a customer may have an email address where the purpose is Billing and another email address where the purpose is Delivery. Now suppose that you want to email a sales order to a customer. In this scenario, you would enter the following token in the To field when emailing the sales order: @Billing@

    The @Billing@ token instructs Microsoft Dynamics AX to perform the following tasks:

    1. Identify the customer that this sales order must be sent to.

    2. Retrieve a list of email addresses for the customer that have the Billing purpose.

    3. Send the sales order to the customer by using the email addresses that are retrieved in step 2.

For more information about how to insert tokens when you send a report as email, see Print or email a report.

Developers can customize the functionality of the tokens by using the SysExtension framework. For example, you can develop an additional customization to retrieve titles from an external address book and send a report to the list of addresses that is retrieved externally.

You can also customize tokens to specify other print destinations by using print management. For example, you can use tokens to specify a printer based on location. In this scenario, a token such as @wh printer@ can be used to specify a warehouse printer.

For more information about how to extend tokens, see Customizing tokens for emailing and printing reports.

New methods for advanced printer properties

The SRSPrintDestinationSettings class contains new methods that let you choose the following printer properties:

  • Print orientation (portrait or landscape)

  • Number of copies to print

  • Target printer tray

  • Collation of printed documents

Updated Compare Tool for Reporting Services reports

The Compare Tool has been updated to support comparison of two Reporting Services report designs.

Management Reporter now installed with Microsoft Dynamics AX

Management Reporter is a tool that you should use to create financial reports. Management Reporter can now be installed when you install Microsoft Dynamics AX. For installation instructions, see Install Management Reporter server components.

For more information about how to configure and use Management Reporter, see the Management Reporter configuration guide and blog.

New features in Microsoft Dynamics AX 2012 R2

The following reporting features have been added in AX 2012 R2.

Support for data partitions

An installation of AX 2012 R2 can consist of multiple data partitions. One report server can support all the data partitions in an AX 2012 R2 installation. For more information about data partitions, see Data partitioning architecture.

Support for report servers that run in SharePoint integrated mode

Reporting Services can be installed in either native mode or SharePoint integrated mode. Report servers that run in SharePoint integrated mode are supported by AX 2012 R2.

In SharePoint integrated mode, a report server runs in a SharePoint server farm. Reports are managed and viewed from SharePoint document libraries. For more information, see Overview of Reporting Services.

Support for Power View

Power View is a tool that you can use to create highly-interactive, custom reports. For example, suppose that you want to create a report that shows sales amounts for your retail stores. In this scenario, you can open Power View, connect to the Retail cube, select the fields to display on the report, and then display the report on a Role Center page in Microsoft Dynamics AX.

Note

If Microsoft SQL Server Analysis Services and Enterprise Portal are installed on different computers, you must use Kerberos security to create Power View reports.

For more information about how to create Power View reports, see Create a report by using Power View to connect to a cube.

New features in Microsoft Dynamics AX 2012

The following reporting features have been added in AX 2012.

Simplified installation

In AX 2012, the Setup wizard has been updated to simplify the process of installing the Reporting Services extensions. When you install the Reporting Services extensions, the Setup wizard will:

  1. Verify that prerequisite software has been installed on the server that runs Reporting Services. For more information about the prerequisite software, see the system requirements webpage.

  2. Prompt you to select an instance of Reporting Services. The extensions that you install will be configured to use this instance. For more information, see Install Reporting Services extensions for Microsoft Dynamics AX.

  3. Enable you to deploy the default reports that are included with Microsoft Dynamics AX.

Upgrade information

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. For more information, see Upgrading Reports.

Improvements to the report deployment process

The process of deploying reports has changed in the following ways.

What can you do?

AX 2009

AX 2012

Why is this important?

Where can I find more information?

Deploy reports by using Windows PowerShell.

The Reporting Project Deployment form in Microsoft Dynamics AX is used to deploy reports.

Windows PowerShell is used to deploy reports.

It’s easier to deploy reports.

Deploy the default reports

Deploy reports in multiple languages.

When a single report is deployed, 42 versions of that report are deployed, one version for every language that is supported by Microsoft Dynamics AX.

For example, when you deploy the Sales Order report, 42 versions of that report are deployed: one for English, one for French, one for German, and so on.

When you deploy a report, one version of the report is deployed. That version is rendered into every language that is supported by Microsoft Dynamics AX.

It’s easier and faster to deploy reports.

Deploy the default reports

Security changes

The following changes that pertain to security have been made.

What can you do?

Microsoft Dynamics AX 2009

Microsoft Dynamics AX 2012

Why is this important?

Where can I find more information?

Implement Microsoft Dynamics AX without having to configure Kerberos authentication

Note

If you’re using Microsoft Dynamics AX 2012 R2, see the note about Kerberos authentication in Support for Power View

Kerberos authentication is required for environments where:

  • Enterprise Portal for Microsoft Dynamics AX is installed on a server other than the server that is running Reporting Services and/or Analysis Services.

  • The Reporting Services database exists on a server other than the server that is running the Windows service for Reporting Services.

Kerberos authentication is not required.

It’s easier to implement Microsoft Dynamics AX.

Security settings for reports

Configure security settings in Microsoft Dynamics AX

Security is implemented by using security groups and security keys.

Reports are fully integrated into the new Microsoft Dynamics AX role-based security model. When you help secure data by using duties and privileges, reports automatically respect that security.

It’s easier to configure security settings for reports in Microsoft Dynamics AX, and you can specify with more precision which data is displayed on a report.

Security settings for reports

Security Considerations Creating a Report

Role-based security in Microsoft Dynamics AX

Improvements to report development

The following improvements have been made to the report development process.

What can you do?

AX 2009

AX 2012

Why is this important?

Where can I find more information?

Access data for a report.

To access data, you use Microsoft Dynamics AX queries, data from analysis cubes, external Microsoft SQL Server databases, data methods that access data from Microsoft Dynamics AX or other sources, and managed code.

Use the data access methods that are available in AX 2012 and the report data provider (RDP) framework to define business logic for a report.

When you use Microsoft Dynamics AX queries, the reporting framework was enhanced to support display methods, field groups, and dimensions. When you add a field to a field group, the field is automatically reflected throughout the application. Therefore, reports automatically add the field. Display methods are treated like fields in the query, even though the display method retrieves the data from a different table. Because of the support for dimensions, you can create a report design by using dimension attributes in the data set, and dimension attributes can be used as report parameters.

An RDP class lets you write X++ code to define the business logic for your report.

Report Data Overview

Report Programming Guide

Use labels on a report.

Each language locale requires a .resx file to store localized strings.

Use Microsoft Dynamics AX labels in your reports. These labels can be dynamically resolved at run time.

By using Microsoft Dynamics AX labels on reports, you no longer have to create a .resx file for each language. Therefore less time is required to deploy reports. Only one report definition is required for each report.

How to: Use a Label in a Report

Use data that is based on specific periods on a report.

This feature is not available.

Create a report that has data that is based on specific periods. The reporting framework supports date-effective data.

You do not have to handle date-effective data explicitly for query-based datasets in Microsoft Dynamics AX.

Walkthrough: Creating a Report Bound to Date Effective Data

Use an improved set of developer tools.

You use the X++ Reporting Framework and Microsoft Visual Studio 2008.

Use Microsoft Visual Studio 2010 integration, take advantage of enhancements to auto-design reports, and create precision-design reports that use the chart features in Reporting Services 2008.

This change fits the long-term goal of aligning Microsoft Dynamics AX with the Microsoft technology stack.

This change also lets Microsoft Dynamics AX developers use Reporting Services features, such as rich charting and interactive reports. The following additional improvements have been made to the reporting tools:

  • The Preview option is now enabled for all nodes under the design node.

  • A drop-down list was added to display the possible parameter types.

  • Microsoft PowerPivot and other Open Data Protocol (OData) clients are now supported.

  • Reporting Services sub-reports in precision design are now supported.

  • Report Data Customization Extension (RDCE) uses Windows Event Viewer logging.

  • New expressive charting capabilities are available for precision-design reports.

Creating Reports Overview

Process business logic for data on a report.

You use a report data method and managed code.

Use the RDP framework that supports complex business logic in X++ code.

The RDP framework can support logic to handle data on a report. For example, an amount can be calculated based on a specific field.

How to: Use a Report Data Provider Class in a Report

Report Programming Guide

Use services to access data and business logic for a report.

You use .NET Business Connecter, which has a weakly-typed programming model.

Create a custom service, and access the service from a report.

Queries and RDP use services to access data for a report.

Standards-based service interfaces let you integrate with many platforms.

Services are strongly typed. Therefore issues are found at design time instead of run time.

The reporting framework added a service that can consume an RDP class from an external application. Services let you quickly expose existing X++ business logic without additional coding.

Services and Application Integration Framework (AIF)

How to: Reference a Service from a Data Method

Work with large datasets for a report.

You use a report data method to return a data table.

Create reports that use large datasets. Added functionality now binds to data methods that return data on a page or in a stream of data.

Only the first row of a dataset must be run to determine the report schema. This change makes it easier to work with large datasets. Now you can write business logic that returns data on a page or in a stream of data. You no longer have to fill the data table before you return it. Therefore, you use less memory and resources on the Reporting Server.

Report Data Method Overview

Use Microsoft Dynamics AX metadata to automatically format a report.

You must define the report format explicitly.

Create reports that are automatically formatted based on the formatting that is specified for the extended data types.

Display width, date/time, and numeric formatting are automatically set. All styles and colors were updated so that they are correct.

You can use metadata to determine whether a field or table should be visible on a report.

Report Data Overview

Create an unlimited number of dimension attributes.

The number of dimensions and dimension attributes is limited to three default dimensions and seven user-definable dimension attributes.

Use the query picker, report model, and report generation. All these features were updated so that they reflect improvements to the dimension framework.

Create an unlimited number of dimension attributes by using the dimension framework. You also have more flexibility, because you can combine dimension attributes.

Walkthrough: Creating a Report Bound to a Dimension Data Source

Take advantage of queries by using a surrogate foreign key (SFK).

The tables that report queries use as a data source sometimes contain natural keys, and the text for the fields is not always understandable.

Use queries that now use SFKs instead of natural keys.

Some of the benefits include improved readability, reduced database size, decreased time to upgrade, and fewer data integrity issues.

A lookup was added to the ReportRunUI control for SFK parameters, so that you can filter on a SFK relationship on a report.

Walkthrough: Leveraging Foreign Keys in Query Relations

Access cross-reference information for a Reporting Services report.

This feature is not available.

Use the cross-reference tool together with Reporting Services reports.

You can see what data the report is using. You can also see what objects in the Microsoft Dynamics AX Application Object Tree (AOT) are using the report.

Walkthrough: Using the Cross-Reference Tool with Visual Studio Projects

Define a report that can be flipped from right to left, depending on the language that is set for the report.

A report cannot be flipped from right to left.

A new precision design is required, where all the report items are flipped manually. Therefore, there might be two designs for the same report.

Create a report that is flipped from right to left at run time, depending on the language that is set and the properties that are set on the report.

You no longer have to maintain two report designs for reports that must be flipped from right to left.

Localizing Reports

The AX_CompanyName report parameter has been updated to reflect changes in AX 2012.

The report parameter for the company name, AX_CompanyName, is added to each report at report design time.

The AX_CompanyName report parameter is unique, because it cannot be deleted and does not have to be initialized.

The AX_CompanyName parameter is added only when the query is company-specific.

You can initialize the AX_CompanyName parameter by using built-in methods.

You can add organization parameters to your report, such as Operating Unit or Department.

The AX_CompanyName parameter was created by the Microsoft Dynamics AX framework for queries that are company-specific.

This change reflects the product-wide feature for organization hierarchies.

How to: Create a Company Parameter in a Report

Organizations and organizational hierarchies

Use the improved drill-through functionality on reports.

This feature is not available.

The following changes were made to improve the drill-through functionality on reports:

  • The client no longer uses table IDs. Instead, the client uses table names and field names to determine which menu item the report link should use.

  • The link style is no longer underlined, and the color was changed.

  • The drill-through now opens in a new client window.

Using table and field names reduces ambiguity and errors.

The updated link style is consistent with the link style that users expect. This change improves the look and usability of reports that have links.

Opening a new window for a linked report is consistent with the expected behavior and improves the usability of reports that have links.

Walkthrough: Creating a Drillthrough Report

Parity with the legacy X++ reporting framework

The following features have been added so that Reporting Services reports have the same capabilities as the legacy X++ reports.

What can you do?

AX 2009

AX 2012

Why is this important?

Where can I find more information?

Filter and sort the data on Reporting Services reports.

This feature is not supported.

This feature is supported.

It’s easier to use Reporting Services reports in Microsoft Dynamics AX.

Filter the data on a report

Sort the data on a report

Create auto-reports that run on the Reporting Services platform.

This feature is not supported.

This feature is supported.

You can quickly generate a Reporting Services report by clicking File > Print > Print in a Microsoft Dynamics AX form. You can generate an auto-report that is used only one time. Alternatively, you can create a custom auto-report, and then save the report so that it can be reused later.

Create a report by using the Microsoft Dynamics AX auto-report wizard

Print Reporting Services reports as part of a batch.

This feature is not supported.

This feature is supported.

You can now perform the following tasks:

  • Print a Reporting Services report on a recurring basis.

  • Schedule a Reporting Services report so that it is printed during off-peak hours.

Print or email a report on a recurring basis

Print or email a report during off-peak hours

Manage print settings for Reporting Services reports.

This feature is not supported.

This feature is supported.

You can now perform the following tasks:

  • Modify the print settings of a Reporting Services report, based on the contents of the data that is printed. For example, you can print sales orders that total less than USD 1,000 to printer A, and sales orders that total USD 1,000 or more to printer B.

  • Specify print settings at various levels of the application. For example, you can set up module-level print settings that apply to all documents in a specific module. Alternatively, you can set up customer-level print settings that apply to documents for specific customers.

Print Management Integration Guide