Repeat Headers on Each Page in SSRS

This article will show how to Repeat Headers on Each Page in SSRS. It’s one of the standard requirements that you might face while developing the Table or Matrix reports.

How to Repeat Headers on Each Page in SSRS

We are going to use the below-shown report to explain, Repeat Headers on Each Page in SSRS Reports. Please refer to SSRS Table ReportData Source, and Dataset articles to understand the creation of SSRS Data Source, Dataset, and Table report.

If you observe the below screenshot, It was a normal Table report with Product Name, Color, Sales, and Tax Amount columns.

Repeat Headers on Each Page in SSRS 1

If we navigate to the second page or any other page, we are unable to see the row headers. It becomes very problematical for the end-user to recognize which column data belongs to Sales and Tax.

Repeat Headers on Each Page in SSRS 2

To display the row headers on each page in SSRS, we have to select the Header from the Row Group pane. By default, only detail rows will show in row group pane.

To display the Header group, Click on the down arrow. Next, select the Advanced Mode from the Column Group pane as shown in below screenshot

Repeat Headers on Each Page in SSRS 3

Once you click on the Advanced Mode, it will show the static columns (Header columns) in both row and column groups. Please select the static column presented in row group pane (Header Row Group). Next, go to the properties of this static column

Repeat Headers on Each Page in SSRS 4

Please select the RepeatOnNewPage option and then, Change the RepeatOnNewPage option from default False to TRUE. It will allow the Header text to repeat on every single page in the Report

Repeat Headers on Each Page in SSRS 5

Click on the Preview button to see the SSRS Repeat Headers on Each Page report preview.

Repeat Headers on Each Page in SSRS 6

If you observe the above screenshot, we are showing the 11th page, and the report is displaying Header text.