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
Tuesday, July 17, 2018
Add a Dynamic Parameter
+10 years of experience with hands-on lead-level background in the full life cycle of software development with demonstrated cross-functional team leadership skills.
Programming:
• ERP :Microsoft Dynamics AX 2012
• Language :X++, C#, C++, XAML, Asp.Net, Html, VB.Net, Android
• Environment : Windows XP, Windows 8, Windows 10, Windows Server
• DataBase : Oracle 9i,10g,11g and SqlServer and SQLlite
Subscribe to:
Post Comments (Atom)
Configure the Firewall on the Enterprise Portal Server
After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...
-
In Reporting Services, reports and resources are processed under the security identity of the user who is running the report. If the report ...
-
The below select query will give the both the Sales Line record count and the sum of sales quantity. static void Test_Data(Args _args) ...
-
To integrate Microsoft Dynamics AX and Analysis Services, you must connect Analysis Services to the Application Object Server (AOS). To do s...
No comments:
Post a Comment