Live Chat Icon For mobile
Live Chat Icon

How to Repeat Row and Column Headers on Multiple Pages

Repeat Row and Column Headers on Multiple Pages

Real-time scenarios like historical statements and sales report tables are used to display large amounts of data that will span across several pages. Displaying the table headers at the top of each page gives the table better readability.
The table repeat header configured in three ways:

  • Display column headers on multiple pages
  • Display row headers on multiple pages
  • Repeat a static row or column on multiple pages

In this blog post, we will walk you through the steps to configure the table header to appear on each page. As a first step, open the Bold Report Designer from our demo site.

Blank report in editing view
A blank report in the editing view

Display column headers on multiple pages

Create a table report, referring to this blog or download the previously created company sales report. Open the downloaded report in Bold Report Designer, it displays the output as in the following.

The company sales table before setting up the column repeat header
The company sales table before setting up the column repeat header

To display column headers on several pages,

  1. Select the table report item in the company sales report and open the Properties panel.
  2. Check the Repeat Column check box under the Headers category in the table Properties panel.
  3. Click on the Preview button at the top-right corner. The table header columns are repeated on each page of the report as in the following image.
The company sales table displays column header on every page of the report
The company sales table displays column header on every page of the report

Display row headers on multiple pages

Open the already downloaded company sales report in Bold Report Designer, it displays the output like in the following.

The company sales table before setting up the repeat row header
The company sales table before setting up the repeat row header

To display row headers on several pages,

  1. Select the table report item in the company sales report and open the Properties panel.
  2. Check the Repeat Row check box under the Headers category in the table Properties panel.
  3. Click the Preview button at the top-right corner. The table header rows repeat on each page of the report as in the following image.
The company sales table displays row header on every page of the report
The company sales table displays row header on every page of the report

Repeat a static row or column on multiple pages

Download the previously created product sales report and open it in Bold Report Designer, it displays the output like in the following.

The product sales table before setting up the static row repetition
The product sales table before setting up the static row repetition

To display a static row or column on multiple pages,

  1. Select the table report item and open the Properties panel.
  2. Click the dotted button on the right side of the Grouping panel and select Advanced Mode. Now the Grouping panel displays the hierarchical static and dynamic members of the table groups.
  3. Click a static member in Row Groups and check the RepeatOnNewPage option in the Properties panel.
  4. Set the KeepWithGroup property to After. You must choose one of the following options from the drop-down menu based on your group:
    • After: Keep this selected member with the following group’s members. Set this option to keep a group header with a group.
    • Before: Keep this selected member with the previous group’s members. Set this option to keep a group footer with a group.
    • None: Set this option when you don’t want this member to be kept with the members of the selected row group.
  1. Repeat steps 3 and 4 for as many adjacent members as you want to repeat.
  2. Click Preview. You can see the table header repeated on each page of the report as in the following image.
The product sales table displays static row on every page of the report
The product sales table displays a static row on every page of the report

Conclusion

I hope this blog provided a clear idea on how to configure a table report item using Bold Report Designer to repeat the row and column headers on each page of a report. Look at our demo samples and documentation site to learn more.

If you have any questions, please post them in the comments section. You can also contact us through our contact page or, if you already have an account, you can log in to ask your support question.

Bold Reports offers a 15-day free trial that does not require a credit card. We invite you to sign up and experience Bold Reports for yourself. Give it a try and let us know what you think!

 

Leave a Reply

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.