Collapse

How to repeat the headers with group in a table

To repeat a header with each group in a table in the Bold Reports® Standalone Report Designer, add a parent group with a header row, then set RepeatOnNewPage and KeepWithGroup on the static header row. Follow these steps:

  1. Drag and drop the Table report item from the item panel into the design area and assign the dataset to the table data region. Table with data

  2. Click on the table surface to enable the Grouping Panel in the design view. Grouping panel enabled for the table

  3. Go to Row Groups pane in the grouping panel and open the context menu on the Details group field. Context menu of the Details group

  4. From the context menu, click on the Parent Group... option under the Add Group category. Parent Group option under Add Group

  5. Once you click on the Parent Group option, a Table Group dialog will be opened to configure the grouping. Table Group dialog

    • Group By: Based on the dataset assigned to the table region, dataset fields will be listed in this drop-down or else click on the square icon to create an expression.
    • Add Group Header: Enable this option to add a header to this group.
  6. Choose the dataset field in the Group by drop-down list.

  7. Select Add header to add a header row to the group and select Add footer to add a footer row to the group. And then click on the OK button.

    • Add header - Adds a static row above the group. Add header option in the Table Group dialog

A static row is added above the group in the table data region.

Header row added above the group

In the report preview, each group shows its header.

Group header in the report preview

How do I show the group value in the group header?

You can display the group value in the group header of the table data region.

Merge header cells

  1. Select the header cells and right-click in the cell. Then, click on the Merge Cells option. Merge Cells option for header cells
  2. Now, you can set group content and format the header cell as required using the properties provided in the property panel. Merged group header cell

Repeat header cells

  1. Click on the surface of a table design to enable the grouping panel. Grouping panel for the table
  2. Refer to the Advanced Mode section to enable the advanced mode in grouping panel.
  3. Once you click on the Advanced Mode, it will show the static columns in both row and column groups. Now, select the static column presented in the row group pane (Header Row Group). Static group view
  4. In the properties panel, enable the RepeatOnNewPage property checkbox and set the KeepWithGroup as After. Repeat header properties

Report preview

On the report preview, the header will be added for each group as shown in the following image and the header will repeat in a new page if the group values exceed the existing page.

Repeated group header in the report preview