SSRS Repeat Header rows across the top.

How do you freeze the header rows on a SSRS report so it looks like Excel when you freeze panes and scroll down?  Read on and find how easy it is.

Below is a simple SSRS report that is just listing 3 columns.

rp1

 

Here is what it looks like when it is previewed, nothing fancy just a listing.

 

rp2

 

I need to export it to PDF by clicking the disk icon on the preview screen and choosing PDF.

rp3

 

Here is page 1 of the pdf when opened in Acrobat Reader.  It has the header fields on the top.

rp4

 

However, when I get to page 2, the headers are no longer there.

rp5

 

First you need to go to our report design screen.  On the bottom right (in yellow), click the drop down and select “Advanced Mode”.

rp6

 

After doing that, it shows items in the Row Groups and Column Groups panes.  Click the top row (Static) in the Row Groups pane and then look to the right for its properties.  There is a setting called:  RepeatOnNewPage, change the value to TRUE.

rp7

 

Now do another preview of the report and export it again to a pdf file.  There is a header on the first row.

rp8

 

Scroll down to page 2 or greater, and now you can see the row headers have been added to all of the pages.

rp9

 

There you have it.  It is easy to add header rows once you know where to look.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s