Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

I want to Repeat Page Header on each Page for reports.Repeat on NewPage is not appearing in properties of Tablix member in SSRS 2008

Tags:

How to Repeat Page Header on each Page. Repeat on NewPage Property is not appearing in ssrs 2008 tablix memeber property

like image 918
grace Avatar asked Aug 13 '10 08:08

grace


1 Answers

After a little experimentation, I figured out how to consistently get the table header to repeat on every page.

The setting of the RepeatColumnHeaders property on the tablix seems to have no effect on this behavior. Instead, we have to set it on a static member of the row groups.

To see the static members of the row groups, click on the small drop down arrow on the far right of the row groups/columns groups header. Then select Advanced Mode. Advanced Mode

With the static members of the row group shown, select the first one in the list. The top left cell of the tablix should be selected in the designer.

Now open the property pane and find the property RepeatOnNewPage and set it to True. RepeatOnNewPage

Then find the property KeepWithGroup and make sure it's set to After. If it's not, set it to After. Now your table header will repeat on every page.

like image 174
Ravi Patel Avatar answered Sep 21 '22 17:09

Ravi Patel