A report is developed, but then the customer makes a request to have the headers visible as they vertically scroll.

What do you do?

When you try to set up Tablix property for keep header visible while scrolling, you will see that it is not working in SSRS 2008 or SSRS 2008 R2. You need to take some extra steps to set up this property

1) Uncheck keep header visible while scrolling tab under tablix property



2) Go to Grouping and Click on the right side arrow (Advanced Mode)

3) Select the first Static Property in Row Groups (In your report first row should display column headers)

4) Make Fixed Data = True


5) Run the report and you will get column headers visible while scrolling

...and for paging purposes, make sure to update this property too:

6) KeepwithGroup to After

...special thanks to hardikabhavsar@:

http://www.bidn.com/blogs/hardikabhavsar/bidn-blog/1638/keep-column-headers-visible-while-scrolling-in-ssrs-2008