A group organizes the report dataset in a data regions. It helps to present the different views of the same data in a data regions.
The following snap shows the areas for a tablix region with nested row groups and column groups
Groups are organized as members of one or more hierarchies for each data region. A group hierarchy has parent/child groups that are nested and can have adjacent groups. Data associated with row group members expands horizontally across the page and data associated with column group members expands vertically down the page. The
Grouping panel displays row group and column group members for the currently selected tablix data region on the design surface.
A group has a name and a set of group expressions. The set of group expressions can be a dataset field or a combination of multiple expressions. During the data processing, the group expressions are combined and the resultant data is applied to the specific group. For example, if a group has date field to organize the data in the data region. On report preview, data is organized by date, and then displayed with other dataset values for each date.
By default, a table, matrix, or list, report items created with
Details group only. You can create groups manually to organize and group data in the tablix data regions.
Details Group - The Details group displays all data from the dataset after applying the dataset and data region filters. The
Details group is the only group that has no group expression. By default, a table or list report item is created with the Details group and adds a row to display the detail data. On report preview, the details row repeats once for every value in the data which is applied to the respective data region. Refer Create Details Group section to create details group in tablix data region.
A details group is added as a child group in the Grouping panel, you cannot add child group to the details group further.
After creating groups, the group properties such as filters, sort, and groups expressions can be modified to organize the data visualization of the respective group in data region. To edit an existing group, select the respective member in the Row or Column Groups pane of the grouping panel. Now, the respective member properties will be listed in the properties panel.
Refer Group properties section and modify the group properties.
You can create a nested group or adjacent groups in the data regions. The scope of group is defined by the hierarchy in which the groups are created in the data regions. To easily understand the scope of the groups in the selected tablix data region,