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.
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.Advanced Mode
RowGroups
section you will find '(Static)' and '(Details)'. click on/highlight (Static)
and press F4 (to check its properties on the Properties
window.)Keep With Group
to After
Repeat On New Page
to True
Tablix Properties
.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
)