SSRS reports - Repeat header on new page

Today, I will be discussing about one of the common issue which we might face and that is related to repeating header on new page.

As we all know that in SSRS reports there is already checkbox on tablix  properties which is used for repeating row header. However, it might not work some time.

So here is work around for it.

Step 1) Go to your tablix first and column group. Now right click on its corner. Then select advance mode.

Step 2) Go to row group and select on static above details group.

Step 3) Go to properties of row (static) and this is tablix member. Now set true to repeat on new page property. Keep with group property to after.

Your header will be repeated on each page :D