In this article we will show you, How to Keep Headers Visible While Scrolling 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 Keep Headers Visible While Scrolling in SSRS
We are going to use below shown report to explain, Keep Headers Visible While Scrolling in SSRS Reports. Please refer 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 Scroll Down a bit we are unable to see the row headers. This become 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 while scrolling in 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 and 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) and go to the properties of this static column
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
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 the middle of the 7th page and the report is displaying Header text.
Thank You for Visiting Our Blog