This SSRS article shows how to repeat the Report header and title on each page 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 screenshot 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.
As you can see, we have named the text box sales by country and formatted the font and background color.
The below image shows the report preview.
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.
If you look at the SSRS preview now, you can see the report header and the title repeated on 3rd page.
