Repeat Table Header on Each Page in SSRS

Repeat Table Header on Each Page in SSRS.

Currently I am working in one SSRS Tablix Report. In that report, I stuck up with the issue that is Table Header is not repeating on every page. I set the RepeatColumnHeaders property to True but it doesn’t make any effect on my report.

Solution :

In this scenario, we have to set the some properties of static member of the row groups.

To see the static members of the row groups of the tablix, select tablix and click on the small drop down arrow on the right side of the Row Groups/Columns Groups header. Then select Advanced Mode.

Please see below screenshot.

1-Repeat Table Header on Each Page in SSRS

Now you can see the static members of row groups. Now select 1st static member. After selecting 1st member, top left cell of the tablix will be selected in the report designer.

2-Repeat Table Header on Each Page in SSRS

Now press F4 or manually open property page. In that, set property RepeatOnNewPage to True. Also set KeepWithGroup property to After.

3-Repeat Table Header on Each Page in SSRS

Now run your report. You will see that your table header will repeat on every page of report.

If still issue is not solved then set FixedData property to True in property page of first static member in row group. It will reproduce table header on every page of report.

4-Repeat Table Header on Each Page in SSRS

Sometimes you don’t need to set all three properties, but it doesn’t do any harm so let’s set all three properties.

If you find any similar issue after setting this properties, let me know.

For contact information, go to following link :

http://bhushan.extreme-advice.com/about-bhushan-shah/