1. In Model Editor, expand the AutoDesign1 node.
2. Right-click the Groupings node under the CustTransListTable data region, and then click Add Grouping.
3. Type Group1 as the name.
4. In the Properties window, set the Label property to "=Fields!AccountNum.Value".
5. Right-click the Group on node, and then click Add Group on.
6. Type "AccountNum" as the name.
7. In the Properties window, set the Expression property to
"=Fields!AccountNum.Value".
8. In Model Editor, expand the AutoDesign1 node, and then select the AccountNum field under the Data region.
9. Right-click the Group1 node and then click Properties.
10. In the Properties window, expand the Instance Aggregates, and set Render Location to "GroupFooter".
11. Select the AmountMST field under the Data node.
12. In the Properties window, expand the Aggregation item, and set Aggregate Function to "Sum".
Best Regards,
Hossein Karimi
Monday, July 16, 2018
Group 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