Forum Discussion
Paginated Report headers not repeating
- 4 months ago
Hi sufregs ,
Thank you for your patience, and apologies for the delay. Also, thank you for sharing the RDL and data.
I tested a similar configuration with the same settings (RepeatOnNewPage = True and KeepWithGroup = After on the header static members, along with page breaks between COUNTY instances), and in my test the header rows repeated correctly when the same group continued onto the next page.
This suggests the behavior depends on how pagination occurs relative to the tablix hierarchy. In your report, since the data expands within nested groups (LA_PROP_CLASS and TAX_DIST_DESC_GRP), the pagination may be occurring at a different level than the COUNTY-level tablix member associated with the header, which can affect the repeat behavior.
To improve consistency, you may consider aligning the header rows with the tablix member that spans across pages, or simplifying the grouping structure.
Alternatively, if the headers are static, placing them in the report header section can ensure they appear on every page.
For Reference:
Grouping pane in a paginated report (Report Builder)Attaching rdl file for reference.
Hope this helps. Please reach out for further assistance.
Thank you.
- 4 months ago
Hi sufregs ,
Thank you for the update.
I understand the behavior you’re seeing. When the header is tied to the COUNTY group, it may not always repeat consistently, and when tied to the child group (LA_PROP), it repeats within the same page.
This appears to be related to how RepeatOnNewPage works with nested groups, where the repeat behavior depends on the group the header is associated with and how pagination occurs.
If restructuring the grouping is not feasible, one possible approach is to keep the header at the COUNTY level and adjust the layout to reduce the impact of nested groups on pagination. Otherwise, this may be considered a limitation of the current tablix rendering behavior.
Please let me know once you are able to test the sample RDL.
Thank you for your response. I have done exactly what you proposed yet the header does not repeat. The rows containing schedule, company column 1, coln2, coln3, etc are all header rows I want to repeat. I have selected the static member corresponding to each of these rows and set repeat on new page = true, as well as keep with group = after.
Any help troubleshooting this will be appreciated.
Hi sufregs ,
Thank you for confirming and for sharing the screenshot.
Since you have already applied RepeatOnNewPage = True and KeepWithGroup = After to the Static members corresponding to those header rows, that configuration is generally the correct approach.
As the COUNTYGRP has a page break configured between each instance, each county will start on a new page. The RepeatOnNewPage property comes into effect only when the rows associated with that tablix member continue onto another page within the same group instance.
Could you confirm whether the data for a single COUNTY instance spans more than one page, or if each county fits within one page before the next page break occurs? If the page break happens before the content extends beyond a page, the repeat behavior would not be triggered.
More details on how repeating headers work with tablix members can be found here:
Display headers and footers with a group in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
Hope this helps. Please reach out for further assistance.
Thank you.