- Microsoft Dynamics AX 2012 Reporting Cookbook
- Kamalakannan Elangovan
- 306字
- 2021-08-06 16:40:50
Aggregation in reports
Totals are an obvious need in most of the reports. SSRS brings in 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…
Reports can be aggregated as follows:
- 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 the transaction, 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.
- Right-click on Add and select Field.
- Set the following properties:
- Preview the report and notice that the aggregated values appear with the customer details. The transactions column indicate the number of records, while the other is the total value of the transactions.
How it works…
Aggregation provides the ability to calculate data based on various functions such as Count
, Sum
, Avg
, Min
, and Max
. These are applicable to a data region or a dataset. The results of the aggregation can be displayed based on the data region.
When a certain field is to be displayed aggregated in the entire report, then aggregation can be configured in the property of the field in the dataset. Each field has a property called Aggregate Function, which must be configured in this case. If the aggregation is only for the specific data region, then it must be defined in the report control in the data region.
Aggregate function results can be displayed as a summary in the header/footer for the table and list data regions. While in the matrix report, the columns and rows can be aggregated to display a grand total.
- Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c
- 資本的眼睛
- 金融科技(FinTech)發展的國際經驗和中國政策取向(中國金融四十人論壇書系)
- Magento 2 Cookbook
- 基本有用的計量經濟學
- 風險導向審計準則實施效果研究
- 內審兵法
- 項目管理實務(第二版)
- Stata統計分析與行業應用案例詳解(第2版)
- 中國國內生產總值核算問題研究
- Microsoft Dynamics CRM 2016 Customization(Second Edition)
- 統計學視角下的金融高頻數據挖掘理論與方法研究
- Amazon EC2 Cookbook
- 審計定價問題研究
- 汪博士解讀PMP?考試(第6版)