How to: Add or Delete a Report

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

This topic explains how to add a Microsoft Dynamics AX report in Visual Studio.

SQL Server Reporting Services is the primary reporting platform for Microsoft Dynamics AX. Reporting Services is a server-based reporting platform that includes a complete set of tools to create, manage, and deliver reports, and APIs that enable you to integrate or extend data and report processing in custom applications. Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components.

In a Visual Studio reporting project for Microsoft Dynamics AX, you can define a report in a report model. A report consists of a collection of items, such as datasets, parameters, images, and report designs. A model can contain more than one report.

To add a report

• In Solution Explorer, right-click the reporting project that you want to add a report to, point to Add, and then click Report. The report model displays in Model Editor, and the node for the report appears expanded in Model Editor.

  Warning

  A report must have at least one dataset and at least one design. Auto design and precision design reports are supported. If not, you will get warnings when you build the reporting project.

The next steps are to define the elements that make up the report. The following list provides links to topics that describe how to define the report elements using the Visual Studio tools for Microsoft Dynamics AX.

1. Add detail to the report. You can work with data regions, display an image, and add a report or style template.

2. Add interactive features like the following:

   • Drill down and drill up actions

   • Document map

   • Report parameters

   • Dynamic filters

   • Report filters

   • Link to another report

   • Link to a URL or a form

   • Specify a chart axis value

3. Localize the report by using labels for localizable text.

4. Deploy the report to the report server.

5. View the report in Report Manager using the URL: http://[MachineName]/reports

6. View the report in Microsoft Dynamics AX by creating a menu item for the report.

To delete a report

• In Solution Explorer or Model Editor, right-click the report that you want to delete, and then click Delete.

See also

How to: Add an Existing Report to a Reporting Project

How to: Define a Report Dataset

How to: Create an Auto Design for a Report

How to: Create a Precision Design for a Report

Walkthrough: Creating an Auto Design Report

Walkthrough: Referencing a Report Parameter from Multiple Datasets in a Precision Design Report