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.
2条答案
按热度按时间osh3o9ms1#
Row Groups
andColumn Groups
(left and right, respectively). BesideColumn 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 theProperties
window.)Keep With Group
toAfter
Repeat On New Page
toTrue
Tablix Properties
.Repeat header columns on each page
andrepeat header column on each Row
. (Edit as of VS2012 at least he might meanRepeat header rows on each page
)6tr1vspr2#
Its nothing but a property for the report named RepeatOnNewPage is false. If you click on the page header and go for page header properties
General --> Display header for this page -> Print on first page and print on last page(check all the boxes over here )and click ok
Run the report. This is done on report builder 3.0 .I am not sure which tool you are using.
Or you can follow this
Select the Tablix.
In the grouping pane, click on the small triangle and select "Advanced Mode" to show static members.
In the row group hierarchy, select the corresponding (static) item of the header row.
In the Properties grid:
set RepeatOnNewPage to True