Excel

Saturday, June 25, 2011

Repeat Header / Keep Header Visible in Tables in RS 2008

               When I tried to set the properties like ‘Repeat header rows on each page’ or ‘Keep header rows visible while scrolling’ -  it doesn’t work in SSRS 2008. Through the searches, I found the following solution for it.
            In the grouping pane of the report page, click on the small triangle and select "Advanced Mode"

It will give you a list of static members in the selected Tablix.
Select the corresponding static and press F4 to see its properties
In the properties window :
- set KeepWithGroup to After
- set RepeatOnNewPage to True for repeating headers
- set FixedData to True for keeping headers visible 
Now click to preview the report...the selected static (Header Row) will be displayed in each page of the report. !!