Report group headings not repeating on every page

Question

I have an RDLC report with three tables and associated data sets. In my second table, I cannot get the two 'header' rows to repeat on each printed page. When viewed interactively, each table is on its own page and this isn't a problem. When I switch to print layout, e.g. my second table now spans two pages, and the second page gets no header rows.

Am I missing a setting or something?

ADDED: I do have the 'Repeat Header columns on each page' checked.

Answer 1

http://vbcity.com/blogs/xtab/archive/2010/06/14/what-to-do-when-the-repeatcolumnheaders-property-in-a-tablix-isn-t-working.aspx

That should help you out for getting them to repeat. (some of the time)

I still have an issue where I set the hidden value to an expression for the next group header that some of the time it won't render my group header on the next page. Very annoying. If someone knows of a fix for this please let me know.

Answer 2

Copied from Microsoft Technet Article. Helped me:

To display a static tablix member (row or column) on multiple pages.

1. On the design surface, click the row or column handle of the tablix data region to select it. The Grouping pane displays the row and column groups.

2. On the right side of the Grouping pane, click the down arrow, and then click Advanced Mode. The Row Groups pane displays the hierarchical static and dynamic members for the row groups hierarchy and the Column groups pane shows a similar display for the column groups hierarchy.

3. Click the static member that corresponds to the static member (row or column) that you want to remain visible while scrolling. The Properties pane displays the Tablix Member properties.

4. In the Properties pane, set RepeatOnNewPage to True.

5. Repeat this for as many adjacent members as you want to repeat.