Freeze tablix header while scrolling and repeat on each page

Freeze tablix header while scrolling and repeat on each page

Posted by muhammadsalmanx on March 28, 2011

There could be a frustrating situation when someone would try to freeze the tablix headers and enable the option to repeat header on each page after selecting related Tablix properties in SSRS 2008 versions.

The options are there but unfortunately these options won’t work. This seems to be a bug that will be fixed very soon hopefully. But meanwhile if someone finds himself in the same situation and enabling of related checkboxes to freeze rows or column headers and to repeat headers on each page as shown in followig diagram is not working then configure these options as shonw in second diagram.

To enable these options perform following steps:

1. Click on the small arrow on right top of the grouping panel and selec Advanced Mode

2. The static groups will be visible. Select the top most static group

3. Note that related header is now selected in the tablix

4. In properties panel set the FixedData, KeepTogether and RepeatOnNewPage properties to True and KeepWithGroup propert to After. This will freeze the header and repeat it on every new page.