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.

Question

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

Answer 1

You can't repeat row 1 of a tablix on each page of a report.

However, the report does have a Page Header section, which can be activated from the Report menu in report designer. Report objects (such as text boxes) placed in the Page Header section will be repeated on every page of the report.

So to repeat the headings on every page, move them out of the tablix and into the Page Header section.

Answer 2

You can repeat page headings on every page if your page breaks are due to breaks between groups (hard pagination). You cannot repeat page headings between pages if the pagination is due to a small interactive page size (soft pagination). To repeat page headers on each page between groups, make the headers of the tablix part of the group and under the General tab of the Tablix Properties window check Column Headers -> Repeat header rows on each page. You can also do this from the general properties window of the Tablix by using the RepeatcolumnHeaders = True.

Please note my comments are limited to developing SSRS 2008 reports in BIDS. I do not know if this functionality exists in Report Builder.

Answer 3

You could also turn on "Advanced Mode" in the Row/Column Groups window and then modify each Static Row entries "RepeatOnNewPage" setting. You'll probably have to set "KeepWithGroup" to "After" as well.

This works well if you utilize a subreport as your header.