Forum Discussion
Paginated Report headers not repeating
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.
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.
Thanks for the response.
Can you explain further what you mean by
"You may want to confirm that the header row is tied to the correct static tablix member that corresponds to the row actually spanning the page break. In some cases the header appears part of a group, but the repeat behavior depends on the underlying tablix member structure."
The header row is tied to my COUNTY group (which is a child group). Below this group are 2 other groups before the Details. The other child group headers are not set to repeat, only the COUNTY is.
The COUNTY group has page break to occur between each instance of a group as different counties need to appear on separate pages.
Tablix (properties accessed by right-click from the left handle) has Keep Together as False
Hi sufregs ,
Thank you for the additional details and the screenshots.
What I meant in the earlier message is that in Advanced Mode the repeat behavior is controlled by the specific Static tablix member that represents the header row, not by the group itself. Even when a header visually appears to belong to a group (such as COUNTYGRP), there can be multiple Static members around that group in the Row Groups pane, and only the one that corresponds to the actual header row controls the RepeatOnNewPage behavior.
From the screenshot, there are several Static items under COUNTYGRP, so the key step is to select each Static member and see which one highlights the row containing the column headers (for example the row with COMPANY, COLNAME1, COLNM3, etc.). That specific Static member should have KeepWithGroup = After and RepeatOnNewPage = True.
Since you also mentioned that COUNTYGRP has a page break between each instance, each county will start on a new page. In that setup the header will normally appear once per county page, but if the content within a single county spans multiple pages, the header should repeat when the correct Static member has the repeat properties.
Reference documentation: Control row & column headings in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
If possible, please confirm which Static member highlights the column header row in the designer when selected, as that will help verify whether the repeat properties are applied to the correct tablix member.
Hope this helps. Please reach out for further assistance.
Thank you.
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 LearnHope this helps. Please reach out for further assistance.
Thank you.