How to: Use Display Methods in a Report
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
This topic explains how to retrieve data for a Microsoft Dynamics AX report from display methods. A display method is treated like a field in a query, even though the display method is retrieving the data from a different table. For information on how to create display methods, see Using the display Method Modifier. In a Visual Studio reporting project for Microsoft Dynamics AX, you can define a report in a report model. You will define a dataset with properties that describe the data that will be used on the report and how it will be retrieved. To show data from a display method, you will bind the dataset to an AX Query. An AX Query is a query defined in the AOT.
Retrieving Data from Display Methods
The following procedure describes how to retrieve data from display methods.
To retrieve data from display methods
In Solution Explorer, right-click the project, point to Add, and then click Report.
In Model Editor, right-click the new report, click Rename, and then give the report a name.
Right-click the Datasets node, and then click Add Dataset.
Select the node for the dataset.
In the Properties window, specify the following values.
Dynamics AX - The data source for the dataset must be set to Dynamics AX if you want to set the data source type to an AX Query.
Data Source Type
Query indicates you will bind the dataset to an AX Query.
The default data region type for the dataset. Specify a value for this property if you plan to use the dataset in an auto design report. For more information about data region types, see Report Data Region Overview.
Set the Dynamic Filters property to True to create dynamic filters on your report. When this value is True, a dataset parameter and report parameter will be created. Both of which will have the same name. When the value is False, the dataset parameter and report parameter for the default ranges are created. For more information about how to create dynamic filters, see Adding Interactive Features to Reports.
Provide a name for the dataset.
Click the ellipsis button (…). A dialog box is displayed with the queries that are defined in the AOT. Select a query and then click Next. Expand the All Display Methods node and select display methods that you want to use on the report. Click OK.
Next, you can drag the dataset onto the Designs node. An auto design named AutoDesign1 is created for the report. For the complete steps to create a report that shows data from display methods, see Walkthrough: Creating a Report with Parameters.