Paginated Report headers not repeating

[sufregs]

Hi Everyone. 

I have a paginated report that is a Tablix (one column report). It has 4 Row groups within it. My header is set on the COUNTY group (2nd one in hierarchy). I have been unablee to get this header to Repeat when the report for that groups spills to another page. 

What I have done

1. On Static row in COUNTY Group: Set KeepwithGroup = After; RepeatonNewPage = True

2. Set KeepTogether = False on textbox properties

For testing, I set another child group header to repeat as well but it is inconsistent across the report. Sometime it repeats, sometimes it doesnt.
Any help will be appreciated.

[sufregs]

Hi.

How and why would the page break happen before the content spills to another page? Page break is set to happen at the instance of another COUNTY.

To your question, yes in some occasions the content for same County spill over to another page. That is why I want the header rows repeated. On other instances, the content is able to fit a page and this works great.

FYI; My tablix is 1 column, multiple rows

[collinq]

Hi @sufregs ,

I think the issue here might be the difference betwen "group header" and "table/tablix header".

If found some instructions online for you that should help you out:

Even if you set RepeatOnNewPage=True, it only works if you set it on the static tablix member that corresponds to the header row (not the group itself, not the textbox).

Steps

1. Click the tablix.
2. In the Grouping pane (Row Groups / Column Groups), click the dropdown ▾ on the right.
3. Turn on Advanced Mode.
4. In Row Groups, you will now see Static items above/between your groups.
5. Click each Static item and look at:
   • Which one highlights your COUNTY header row in the designer?
   • That is the one you must set.

[sufregs]

Thank you for the response. That is exactly what I did for all the static members that make up the header but it still does not repeat

[v-veshwara-msft]

Hi @sufregs ,

Thank you for the update.

If the properties were already set on the correct Static member in Advanced Mode and the header still does not repeat, it may be worth checking whether any page break settings on the groups are affecting pagination. For example, if a parent or child group has a page break configured (start, end, or between instances), it can sometimes affect how headers repeat when the tablix spans multiple pages.

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.

Could you also check whether the COUNTY group has any page break settings enabled and whether the tablix has KeepTogether = False? These settings can influence pagination behavior.

More details about how repeating headers work with tablix members and group pagination can be found here:

Display headers and footers with a group in a paginated report - Microsoft Report Builder & Power BI...

Control row & column headings in a paginated report - Microsoft Report Builder & Power BI Report Bui...

Similar thread: Solved: Re: Report Builder Column Headers are Not Repeatin... - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.
Thank you.

[sufregs]

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

[v-veshwara-msft]

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 Bui...

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.

[sufregs]

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. 

[v-veshwara-msft]

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...

Hope this helps. Please reach out for further assistance.

Thank you.