How to repeat the headers with group in a table?
Organizing data into logical groups is essential for creating reports that are easy to read and analyze. Bold Reports Designer provides powerful grouping features that allow you to add headers and footers to table data regions, making your reports more structured and visually appealing. This article explains how to achieve grouping in Tablix. By following these steps, you can enhance the clarity and usability of your reports for better data presentation.
-
Drag and drop the Table report item from the item panel into the design area and assign the dataset to the table data region.
-
Click on the table surface to enable the Grouping Panel in the design view.
-
Go to Row Groups pane in the grouping panel and open the context menu on the Details group field.
-
From the context menu, click on the Parent Group… option under the Add Group category.
-
Once you click on the Parent Group option, a Table Group dialog will be opened to configure the grouping.
- 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
-
Choose the dataset field in the Group by drop-down list.
-
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.
Now, a static row will be added above of the group in the table data region.
Format header and footer
You can display the group value in the group header of the table data region.
Merge header cells
- Select the header cells and right-click in the cell. Then, click on the Merge Cells option.
- Now, you can set group content and format the header cell as required using the properties provided in the property panel.
Repeat header cells
-
Click on the surface of a table design to enable the grouping panel.
-
Refer to the Advanced Mode section to enable the advanced mode in grouping panel.
-
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).
-
In the properties panel, enable the RepeatOnNewPage property checkbox and set the KeepWithGroup as After.
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.
