Keep Headers Visible While Scrolling in SSRS

In this article, we will show you how to Keep Headers Visible While Scrolling in SSRS. It is one of the standard requirements that you might face while developing the Table or Matrix reports.

How to Keep Headers Visible While Scrolling in SSRS

We are going to use the below-shown report to explain, Keep Headers Visible While Scrolling in SSRS Reports. Please refer to Table ReportData Source, and Dataset articles to understand the creation of Data Source, Dataset, and SSRS Table report.

From the below screenshot, you can see, It was a standard Table report with Product Name, Color, Sales, and Tax Amount columns.

Keep Headers Visible While Scrolling in SSRS 1

If we Scroll Down a bit, we are unable to see the row headers. It becomes very problematic to identify which column data belongs to Sales and Tax, as shown in the below screenshot.

Keep Headers Visible While Scrolling in SSRS 2

To display the row headers while scrolling on every page in SSRS, We have to select the Header from the Row Group pane. By default, only detail rows will show up in row group pane.

To display the Header group, Click on the down arrow and select the Advanced Mode from the Column Group pane

Keep Headers Visible While Scrolling 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) and go to the properties of this static column

Keep Headers Visible While Scrolling in SSRS 4

Please select the FixedData option and then, Change the FixedData option from default False to TRUE. It will allow the Header text to freeze when we are scrolling the SSRS Report

Keep Headers Visible While Scrolling in SSRS 5

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 SSRS Report

Keep Headers Visible While Scrolling in SSRS 6

Click on the Preview button to see the SSSR Keep Headers Visible While Scrolling report preview.

Keep Headers Visible While Scrolling in SSRS 7

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