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 Report, Data 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.
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.
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.
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.
Click the Preview button to preview the SSRS Repeat Headers on Each Page report.
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. Please refer Add TextBox article.
As you can see, we have named the text box sales by country and formatted the font and background color. 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.
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.
Select the Static under the Row Groups section to see the properties. Change the RepeatOnNewPage property from False to True to repeat the report heard on each page.
Looking at the SSRS preview now, you can see the report header and the title repeated on 3rd page.
