Aggregation in reports
Aggregate functions are very useful in SSRS reports in AX R3 to calculate the aggregate values that show the numeric data. Totals are an obvious need in all reports. For example, the sum aggregate function calculates the total of transaction amounts. SSRS provides easy and powerful aggregation capabilities. This recipe will discuss a couple of aggregation methods and how they can be applied at different levels.
How to do it…
In this recipe two aggregations will be implemented:
- Total value of transactions per customer
- Count of the total number of transactions per customer
To define the total value of transactions implement the following steps:
- Navigate to the Data | AmountMst node.
- Set the Aggregation Function property to Sum.
To display the count of records implement the following steps:
- Go to the Groupings | AccountNum node in the table data region as shown in the following screenshot:
- Right-click and go to Add | Field.
- Set the following properties:
Property
Value
...
