How to create a custom report [AX 2012]
Updated: December 3, 2012
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
There are several ways to create a custom report. The following table lists the tools that you can use to create a custom report if you are a system administrator or an application user.
| Category | Tool that is used to create the report | Format of the report | For more information |
|---|---|---|---|
| Transactional reports Transactional reports retrieve data from the transaction processing database for Microsoft Dynamics AX. | Microsoft Dynamics AX list page | Excel worksheet | |
| Microsoft Dynamics AX auto-report wizard | Reporting Services report | Create a report by using the Microsoft Dynamics AX auto-report wizard | |
| Microsoft Dynamics AX add-in for Excel | Excel worksheet | ||
| Management Reporter for Microsoft Dynamics ERP | Management Reporter report | Microsoft Management Reporter: Installation, Migration, and Configuration Guides | |
| Analytical reports Analytical reports retrieve data from Microsoft SQL Server Analysis Services cubes. | Excel | Excel worksheet | Create a report by using the Excel data connection wizard to connect to a cube |
| SQL Server Report Builder | Reporting Services report | Create a report by using SQL Server Report Builder to connect to a cube | |
| SQL Server Power View | Reporting Services report |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
