SSRS : How to repeat header row of a table on each page that is embedded in a LIST?
reporting-services, sql-server, ssrs-tablix
Solution
- 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.
- Check `Advanced Mode`
- 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.)
- Set `Keep With Group` to `After`
- Set `Repeat On New Page` to `True`
- Go back to table, right-click on the row header (the grey bar), and select to `Tablix Properties`.
- 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`)
Problem
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.