Filter Report Data

Hossein.K

6,642

Like ( 0 )

Report

1. Open Microsoft Dynamics AX.

2. In the AOT, expand the Queries node, and then locate the CustTrans_W1 query.

3. Expand the CustTrans_W1 node and expand the Data Sources node.

4. Right-click the Ranges node and then click New Range. A default range using the AccountNum field is created for you by AX.

5. Save the query.

6. In Visual Studio Model Editor, select the CustTransListDS node.

7. Right-click the node and select Refresh to reflect changes that you make to the AX Query.

8. Expand the Parameters node for the report (that is not the Parameters node for the dataset) to display the list of report parameters.

9. Right-click the node and select Add > Parameter.

10. Type "AccountParam" as the name.

11. In the Properties window, enter Account for the Prompt String property.

12. Save the report.

13. In Model Editor, expand the nodes of AutoDesign1 to see the Filters node.

14. Right-click the Filters node and select Add Filter.

15. Type "AccountFilter" as the name.

16. Set the following properties in the Properties window

a. Expression: =FieldsAccountNum.Value

b. Operator: Like

c. Value: =Parameters!AccountParam.Value

17. Save the report.

Best Regards,
Hossein Karimi