Keep Column Headers Visible While Scrolling in SSRS

To keep column headers visible while scrolling through the report, follow the below steps.

1. Refer to the Simple Table Design section and create a table report as shown below.

   

2. Click on the surface of the table design to enable grouping panel.

   

3. Refer to the Advanced Mode section to enable advanced mode in the grouping panel.

4. Once you click on the Advanced Mode, it will show the static columns in both the row and column group. Now, select the static column presented in the row group pane (Header Row Group).

   

5. In the properties panel, enable the Fixed Data and Repeat On New Page properties checkbox and set Keep With Group as After.

   

   Now, preview your report and try scrolling. Notice that the column header looks messy because its background is transparent by default.

   

6. To fix this, just change the background color of the cells in the header row.

   

   

Download the above report design from the link.