Getting rows of a table to repeat at the top of each page of a report in SSRS 2008 R2 is anything but straightforward. This blog shows the red herring to avoid and a way to solve this thorny problem.

1. How to repeat header rows / page titles in SSRS
2. Using the Group Pane to Repeat Page Titles (this blog)

Posted by Andy Brown on 26 July 2011 | 9 comments

Using the Group Pane to Repeat Page Titles

To get page titles to repeat at the top of each page, you have to jump through a series of hoops.

Designing your Table

The first thing to do is to decide which rows you want to repeat at the top of each page:

Here we‘ll repeat the 4 rows shown selected (notice that we‘ve included a blank row at the top of the table, to provide an offset from the top of each page).

Invoking Advanced Mode in the Grouping Pane

You now need to set properties for each individual row shown above, but unfortunately you can‘t see them in the grouping pane - yet:

Click on the symbol circled and choose Advanced Mode.

Changing Row Properties

What you now need to do for every row to be repeated is to change its properties.  First select the row in the grouping pane:

When you click on the (Static) row in the groupng pane, SSRS shows that it is selected in the main report designer. Keep an eye on this to check you‘ve got the right row selected.

Now change its RepeatOnNewPage property:

Change the property shown to repeat the selected row on each new page.

The Final Result

The final result makes it all worthwhile - each page looks the same at the top:

The second page of the report has the same titles as the first!

But was it really meant to be this hard?