Add a Dynamic Parameter
Views (71)
Hossein.K
6,648
Like
Share
Report
1. Open Microsoft Dynamics AX.
2. Press Ctrl+Shift+W to enter the development environment.
3. In the AOT, right-click the Queries node and then click New Query.
4. Rename the query to CustTable_W1.
5. Expand the CustTable_W1 node.
6. Locate the CustTable table and drag it onto the Data Sources node for the CustTable_W1 query.
7. Locate the AccountNum field under CustTable and drag to the Fields node under the CustTrans_W1 Data Source node.
8. Save the query.
9. In Model Editor, right-click the Datasets node, and then click Add Dataset.
10. Type "CustomersDS" as the name.
11. Select the node for the dataset.
12. In the Properties window, set the following properties.
o Data Source: Dynamics AX
o Data Source Type: Query
o Default Layout: Table
o Name: CustomersDS
o Query: Select * from CustTable_W1
13. In Model Editor, select the AutoDesign1 node.
14. Expand the Parameters node to display the list of report parameters.
15. Select the AccountParam node.
16. In the Properties window, click the button in the Values property.
17. Select From Dataset option button and set the following properties:o Dataset: CustomersDS
o Value Field: AccountNum
o Label Field: AccountNum
18. Click OK.
19. Save the report.
Best Regards,
Hossein Karimi
2. Press Ctrl+Shift+W to enter the development environment.
3. In the AOT, right-click the Queries node and then click New Query.
4. Rename the query to CustTable_W1.
5. Expand the CustTable_W1 node.
6. Locate the CustTable table and drag it onto the Data Sources node for the CustTable_W1 query.
7. Locate the AccountNum field under CustTable and drag to the Fields node under the CustTrans_W1 Data Source node.
8. Save the query.
9. In Model Editor, right-click the Datasets node, and then click Add Dataset.
10. Type "CustomersDS" as the name.
11. Select the node for the dataset.
12. In the Properties window, set the following properties.
o Data Source: Dynamics AX
o Data Source Type: Query
o Default Layout: Table
o Name: CustomersDS
o Query: Select * from CustTable_W1
13. In Model Editor, select the AutoDesign1 node.
14. Expand the Parameters node to display the list of report parameters.
15. Select the AccountParam node.
16. In the Properties window, click the button in the Values property.
17. Select From Dataset option button and set the following properties:o Dataset: CustomersDS
o Value Field: AccountNum
o Label Field: AccountNum
18. Click OK.
19. Save the report.
Best Regards,
Hossein Karimi
*This post is locked for comments