Adding Groups to Tables

Table, Crosstab, and List items are template variations of the same Table data item and use row and column groups to organize data hierarchically. Unlike Report groups, table groups expand both horizontally (column groups) and vertically (row groups) to create flexible data layouts.

Use the Group Explorer to add and manage groups in table items. You can create parent, child, adjacent, or details groups, and configure filtering, sorting, and aggregation settings for each group.

The instructions in this article apply to all three template variations: Table, Crosstab, and List items.

Add a Row/Column Group Using the Report Designer

Add a Parent or Child Group

To add a parent or child row/column group:

1. Select the Table, Crosstab, or List item on the design surface.
2. In the Group Explorer, right-click an existing group.
3. Click Add Group, and then click Parent Group or Child Group depending on where you want to add the group. The Table Group dialog box opens.
4. In the Group by section, click the New button.
5. Enter an expression for the grouping criteria (for example, = Fields.Category).
6. (Optional) Select Add Header to add a group header row or column.
7. (Optional) Select Repeat On Every Page to repeat the header on each page.
8. (Optional) Select Add Footer to add a group footer row or column.
9. (Optional) Select Repeat On Every Page to repeat the footer on each page.
10. Click OK.

The group is added to the Group Explorer hierarchy, and the corresponding rows or columns are added to the data item on the design surface.

Add an Adjacent Group

To add an adjacent row/column group:

1. Select the Table, Crosstab, or List item on the design surface.
2. In the Group Explorer, right-click an existing group.
3. Click Add Group, and then click Adjacent Above or Adjacent Below to specify where to add the group. The Table Group dialog box opens.
4. In the Group by section, click the New button.
5. Enter an expression for the grouping criteria (for example, = Fields.Category).
6. (Optional) Select Add Header to add a group header row or column.
7. (Optional) Select Repeat On Every Page to repeat the header on each page.
8. (Optional) Select Add Footer to add a group footer row or column.
9. (Optional) Select Repeat On Every Page to repeat the footer on each page.
10. Click OK.

The group is added to the Group Explorer at the specified position, and the corresponding rows or columns are added to the data item on the design surface.

Repeatable headers and footers are not compatible with the PageBreak property. If any group in the table has a PageBreak value other than None, repeatable headers and footers will not be processed and rendered, even if PrintOnEveryPage is enabled.

Add a Details Group Using the Report Designer

A details group displays individual data records without grouping. For row groups, this creates a row for each record; for column groups, this creates a column for each record.

To add a details group:

1. Select the Table, Crosstab, or List item on the design surface.
2. In the Group Explorer, right-click the innermost child group.
3. Click Add Group, and then click Child Group. The Table Group dialog box opens.
4. Select Show detail data.
5. Click OK.

The details group is added to the Group Explorer and displays the details group icon. A new row (for row groups) or column (for column groups) is added to the table to display the detail data.

Edit an Existing Group

To edit an existing group's properties, including grouping expressions, sorting, filtering, and other settings:

1. Select the Table, Crosstab, or List item on the design surface.

2. In the Group Explorer, right-click the group, and then click Group Properties.

3. Configure the group properties:

   • GroupKeepTogether—Specify the keep together options to control whether group content stays together across page breaks.
   • PageBreak—Specify where page breaks occur relative to the group.
   • PrintOnEveryPage—For internal use only. This property is automatically set for static groups created when groups have repeatable headers or footers.
   • Visible—Control the visibility of the group.
   • Filters—Click the ellipsis to configure filters. Click New to add a filter, then specify the Expression, Operator, and Value.
   • Groupings—Click the ellipsis to add or modify grouping expressions. Click New to add additional expressions. All expressions are combined using a logical AND.
   • Sortings—Click the ellipsis to configure sort order. Click New to add a sort expression, then choose ASC (ascending) or DESC (descending) from the Direction drop-down list.
   • BookmarkId—Set a bookmark identifier for this group.
   • DocumentMapText—Specify the text to display in the document map for this group.
   • TocText—Specify the text to display in the table of contents for this group.
   • Name—Enter the name of the group.

4. Click OK.

Delete a Group Using the Report Designer

To delete a group:

1. Select the Table, Crosstab, or List item on the design surface.

2. In the Group Explorer, right-click the group, and then click Delete Group.

3. In the Delete Group dialog box, select one of the following options:

   • Delete group and related rows and columns—Choose this option to delete the group definition and all related rows and columns that display group data. For the details group, if the same row or column belongs to both detail and group data, only the detail data rows and columns are deleted.
   • Delete group only—Choose this option to keep the structure of the data item and delete only the group definition.

4. Click OK.

Add a Group Programmatically

C#

            Telerik.Reporting.TableGroup group1 = new Telerik.Reporting.TableGroup();
            group1.Name = "ProductID1";
            group1.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.ProductID"));
            
            // If you need to filter the members of the group, apply filtering
            group1.Filters.Add(new Telerik.Reporting.Filter("=Fields.ProductID", Telerik.Reporting.FilterOperator.Equal, "=10"));
            
            // If you need to order the members of the group, apply sorting
            group1.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.ProductID", Telerik.Reporting.SortDirection.Asc));

            Telerik.Reporting.TextBox textBox1 = new Telerik.Reporting.TextBox();
            table1.Items.Add(textBox1);
            group1.ReportItem = textBox1;
           
            table1.RowGroups.Add(group1);

VB.NET

        Dim group1 As New Telerik.Reporting.TableGroup()
        group1.Name = "RowGroup1"
        group1.Groupings.Add(New Telerik.Reporting.Grouping("=Fields.ProductID"))

        ' If you need to filter the members of the group, apply filtering
        group1.Filters.Add(New Telerik.Reporting.Filter("=Fields.ProductID", Telerik.Reporting.FilterOperator.Equal, "=10"))

        ' If you need to order the members of the group, apply sorting
        group1.Sortings.Add(New Telerik.Reporting.Sorting("=Fields.ProductID", Telerik.Reporting.SortDirection.Asc))

        Dim textBox1 As New Telerik.Reporting.TextBox()
        table1.Items.Add(textBox1)
        group1.ReportItem = textBox1

        table1.RowGroups.Add(group1)

See Also

• Table Group Dialog (Desktop Designers)
• Table Group Dialog (Web Report Designer)
• ColumnGroups
• RowGroups