SSRS: Fixing Headings in Place and Repeating them on New Pages

Nathan Eccles, 04 November 2013

As mentioned in my previous blog, a useful feature available to us through SSRS is the ability to repeat header rows on new pages, or have them fixed as the first row to be displayed on the screen regardless how far down the report you are.

Getting access to these properties can be a bit confusing, but once you’re familiar with how to get there, it’s simple to implement these cool features which make your reports more readable and user friendly!

To get access to these features, you need to open the properties for your heading row. This requires enabling Advanced Mode on your Column and Row Groups.

To do this, click the drop down arrow to the right of Column Groups, and check “Advanced Mode”.

This will bring up a bunch more Rows and Columns within the Groups, each representative of one of the static rows or columns in your report.

Having clicked on the first the first “Static” row we can see that the first item of that row has been selected on the report, indicating to us which row we are dealing with.

From here we can open the Properties window to get access the options for this row.

The properties we’re after are “FixedData”, which will fix this row to stick with you as you scroll down the page, and “RepeatOnNewPage” which does exactly what it says.

After enabling these features we can run our report, and as can be seen in the below images, our header is now floating with us down the page, and when we pop the report open in a PDF we can see that the headers are repeated on the second page (and any pages after that).

If you have multiple header rows, you can simply follow these instructions for each of the rows. Just note that these options are not valid for rows part way down your table, so all the headings that you wish to fix or repeat on new pages must be together at the top of the table.