This sample demonstrates the grouping feature of the pivot table. The pivot fields are automatically populated from the bound data source, and they can be dragged and dropped to alter the report at runtime. The pivot fields can be sorted, filtered, and removed dynamically as well.
The pivot table grouping bar option automatically populates fields from the bound data source and allows end users
to drag fields between different axes such as columns, rows, values, and filters, and create pivot views at runtime.
To enable grouping bar, set the
ShowGroupingBar property as true.
Filter and sort icons allow displaying selective records and ordering them in ascending or descending order. The value type icon allows to display values based on selected aggregate type. The remove icon allows the user to remove the field from the report.
During runtime, the Values button in the grouping bar can be moved to a different position (i.e., different index)
among other fields in the column or row axis. To enable values button,
showValuesButton property to true.
The fields panel, which is located above the grouping bar, displays the fields that are available in the data
source but are not bound in the report. The fields can be dragged and dropped into the appropriate axis. In
addition, any field removed from any axes will be automatically added to the fields panel. The fields panel can
be displayed by setting the
ShowFieldsPanel property in the
GroupingBarSettings to true.