With the term grouping, we mean the capacity of aggregate result sets based on one or more discriminant elements. Grouping is typically used to show totals per group and/or aggregate and calculate totals (typically using sum formulas). The grouping feature is used typically within controls that implement the data region scope, such as table, matrix, list, chart, and gauge.
In this section, we will create group totals for the table control of our report:
- In the Row Groups section, right-click on the (Details) static row group and select Add Group. Choose Parent Group….
- A pop-up window should appear, asking you to provide a grouping element. Select the [ItemNo_ItemLedgerEntry] field value and choose to add both ...
