How to: Define a Report with Dynamic Filters [AX 2012]
Updated: October 11, 2013
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
This topic describes how to define a report that will enable an end user to filter data on any of the fields in the tables in the dataset. A dynamic filter is a filter that is created at runtime. Filters are created using the SySQuery form in the Microsoft Dynamics AX client.
For an example of a report with dynamic filters, go to Accounts receivable > Reports > Customers. Click the Select button to filter the report based the Customer account. The end-user can add filters to the report. For more information on how to use reports with dynamic filters, see Filter the data on a report.
To Define a Report with Dynamic Filters Bound to a Query
In Model Editor, expand the node for the report that you want to work with.
Right-click the Datasets node and then click Add Dataset.
Select the node for the dataset.
The following table shows the properties for a dataset in the Properties window. Specify the following property values.
Data Source Type
True – The end-user of the report can add additional filters when they run the report. A single dataset parameter and report parameter are created to transport the dynamic filters that are set at runtime for the report. A dataset parameter references the report parameter and is set in the Properties window of the dataset parameter in the Report Parameter property. When the Dynamic Filters property is set to True, the default ranges are not created for the report.
False – The filters are static, meaning they are defined in the report model. Dataset parameters and report parameters are created for every range defined in the AX query. The end user of the report will identify the ranges when they view the report. For information about how to define a set range for a filter on a report, see How to: Define a Report Filter.
When the Dynamic Filters property is set to False and the query has tables which have date effective columns, the date effective fields appear as ranges automatically. To disable the date effective fields, set the report parameter Visibility property to Hidden.
Click the ellipsis button (...) to open the Select an AX Query dialog box where you can select a query that is defined in the AOT. In this dialog box, you can also select fields, field groups, display methods and dimensions to be returned by the query.
After you define a dataset, you can drag the dataset onto the Designs node. This will create an auto design for the report displaying the data for the dataset. For more information, see How to: Create an Auto Design for a Report. If you add a precision design report, the Report Data window will contain the datasets that you defined in the model when you edit in SQL Report Designer. For more information, see How to: Create a Precision Design for a Report.