Repeat Headers on Each Page in SSRS

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

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

How to Repeat Headers on Each Page in SSRS

The screenshot below shows that it was a normal Table report with Product Name, Color, Sales, and Tax Amount columns.

Format Fonts and Background of a Textbox 8

We cannot see the row headers if we navigate to the second page or any other page. It becomes very problematic for the end-user to recognize which column data belongs to Sales and Tax.

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

Click the down arrow to display the Header group to Repeat Headers on Each Page in SSRS. Next, select the Advanced Mode from the Column Group pane, as shown in the below screenshot.

SSRS Repeat Header on Each Page 2

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

SSRS Repeat Header on Each Page 3

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.

Set RepeatOnNewPage property to True

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

See The Preview 5

If you observe the above screenshot, we show the 11th page, and the report displays the Header text.

SSRS Repeat Header and Title on each page of a report

This SSRS section shows how to repeat each page’s Report header and title with an example. First, we have to use the Page header and RepeatOnNewPage property.

Right-click on the Datasets folder to create a new DataSet. The code below shows our data set for this SSRS repeat header and title example.

The Sql query that we used above SSRS example is:

SELECT Prod.EnglishProductName AS ProductName, 
       Prod.Color, 
       SUM(Fact.OrderQuantity) AS Orders, 
       SUM(Fact.TotalProductCost) AS ProductCost, 
       SUM(Fact.SalesAmount) AS Sales, 
       SUM(Fact.TaxAmt) AS Tax
FROM FactInternetSales AS Fact
   INNER JOIN DimProduct AS Prod ON Fact.ProductKey = Prod.ProductKey
   GROUP BY Prod.EnglishProductName, Prod.Color

SSRS Repeat Report Header and Title on each Page

We have designed a simple table report and formatted the font and colors. Next, right-click on the empty space, select Insert, and then the text box option to add a text box for the report title.

Insert Text Box

As you can see, we have named the text box sales by country and formatted the font and background color.

Add Title

If you open the report preview, it will show the Sales By Country text box and the header on the first page. However, if you see the 3rd or last page, there is no header or report title.

To repeat the report title on each page, right-click on the empty space, select Insert, and then the Page Header option.

Add Page Header in SSRS to Repeat Header and Title

Drag the Report title from the report area to the page header. Next, click the down arrow beside the Column Groups section and choose the Advanced Mode option.

SSRS Repeat Header and Title Advanced Mode

Select the Static under the Row Groups section to see the properties.

RepeatOnEachPage property

Change the RepeatOnNewPage property from False to True to repeat the report heard on each page.

Change RepeatOnNewPage property in SSRS to Repeat Header and Title

Looking at the SSRS preview now, you can see the report header and the title repeated on 3rd page.

SSRS Repeat Header and Title preview