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
Monday, July 16, 2018
Filter Report Data
+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