Repeating Page Headers in Reporting Services 2008 R2
Part two of a two-part series of blogs

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

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

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:

Table with top 4 rows selected

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:

Tick box to choose Advanced Mode

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:

Grouping pane in advanced mode

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:

RepeatOnNewPage property selected

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:

Second page of repeat with repeating titles

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

 

But was it really meant to be this hard?

For an encore, read the companion blog on getting a page title to stay visible as you scroll down an SSRS report.

 

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