ApplyBI

SSRS – Repeat header on each page

I had a recently got a request to make changes in a SSRS report.
As the output of the report has several pages of information, i was asked to repeat the column header on each page.
So i tried the usual approach that everybody thinks which will work. Which is, in tablix properties, check the option ‘Repeat column headers on each page’. I even tried the other option of ‘Repeat row headers on each page’ and also the combination of these two.

Image: Repeat column header on each page

But, unfortunately and surprisingly, it didn’t work.

So, the solution is simple.
1) Go to Advanced mode by clicking on the down arrow near ‘Column Groups‘.

2) Now you can see the static rows and columns in Row Groups and Column Groups. Here you need to worry about only static rows in Row Groups.

3) Select the static rows which needs to be repeated on each page. You can do this by select any static row and checking which row’s textbox gets selected in the tablix, and static row is the right one. Press F4 to go to it’s properties.

4) Select the option ‘After’ for KeepWithGroup. Select the option ‘True’ for RepeatOnNewPage.

Image: Static row properties

5) Do this for every header which needs to be repeated on every page.

Good Luck !!!

14 comments on “SSRS – Repeat header on each page”

1. Anita on February 25, 2013 at 10:51 pm said:

   Thank you for your help.

   Reply ↓
2. Rick on February 27, 2013 at 3:40 pm said:

   Thank you. It solved my problem of repeated headers in SSRS.

   Reply ↓
3. Nick on March 2, 2013 at 4:19 am said:

   Nice Post. Thanks.

   Reply ↓
4. Aaron on March 3, 2013 at 6:40 am said:

   Thanks 4 ur help

   Reply ↓
5. Bob on March 5, 2013 at 3:50 pm said:

   Great post. I don’t know why Microsoft made this so complicated.

   Reply ↓
6. Alisha on March 7, 2013 at 9:18 am said:

   rather nice post, it really helped me in my SSRS project. Thanks.

   Reply ↓
7. satya on March 11, 2013 at 10:54 am said:

   Thanks 4 ur help

   Reply ↓
8. deepak on March 11, 2013 at 1:45 pm said:

   Nice article. thanks.

   Reply ↓
9. james on March 11, 2013 at 1:50 pm said:

   Nice article. Thanks

   Reply ↓
10. Stan on March 11, 2013 at 3:05 pm said:

    Good work. keep it up

    Reply ↓
11. sri on March 11, 2013 at 11:45 pm said:

    It helped me solve a real irritating problem. Thanks.

    Reply ↓
12. Alex on March 14, 2013 at 1:25 am said:

    Great post. Thank you.

    Reply ↓
13. Richa on March 19, 2013 at 8:52 am said:

    nice article, thnks.

    Reply ↓
14. glen on March 20, 2013 at 10:44 am said:

    Good article. Thanks

    Reply ↓