In this article, we will show you, How to Repeat Headers on Each Page in SQL Server Reporting Services. This is one of the common requirement that you might face while developing the Table, or a 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 Report, Data Source and Dataset articles to understand the creation of Data Source, Dataset and Table report.
If you observe the below screenshot, It was a normal Table report with Product Name, Color, Sales Amount and Tax Amount columns.
If we navigate to the second page or any other page we are unable to see the row headers. This becomes very problematic for the end-user to identify which column data belongs to Sales and Tax as shown in below screenshot.
To display the row headers on each and every page, We have to select the Header from the Row Group pane. By default, only detail rows will be shown in row group pane.
In order 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
Once you Click on the Advanced Mode, it will show the static columns (Header columns) in both row and column group. Please select the static column presented in 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 SSRS Report
Click on the Preview button to see the report preview.
If you observe the above screenshot, We are showing 11th page and the report is displaying Header text.
Thank You for Visiting Our Blog
