sql-serverreporting-servicesssrs-tablix

SSRS : How to repeat header row of a table on each page that is embedded in a LIST?


I have a SSRS report that has a list which includes two embedded tables.

For these tables if I set the header rows to repeat on each page, I get an error "All tablix member elements in a TablixColumnHierarchy must have the RepeatOnNewPage Property set to false".

How do I fix this and make the headers repeat on each page?

Thank you.


Solution

    1. In design mode while editing the rdl file, at bottom of the editor you will find Row Groups and Column Groups (left and right, respectively). Beside Column Groups you will find one arrow button (this arrow button is at the right side of the column groups portion). Click on this arrow button.
    2. Check Advanced Mode
    3. In the RowGroups section you will find '(Static)' and '(Details)'. click on/highlight (Static) and press F4 (to check its properties on the Properties window.)
    4. Set Keep With Group to After
    5. Set Repeat On New Page to True
    6. Go back to table, right-click on the row header (the grey bar), and select to Tablix Properties.
    7. Check on Repeat header columns on each page and repeat header column on each Row. (Edit as of VS2012 at least he might mean Repeat header rows on each page)