Forum Discussion
Paginated Report not showing column headers
Hi,
I have a paginated report set up as per below:
When I run the report, for some strange reason i get missing field headers as highlighted in yellow in snapshot below:
I have no idea at all why this is happening.
Does anyone know?
Thank You
Hi mp390988
This is AI generated and unvalidated, but I hope it helps:
Possible Causes of Missing Field Headers
Visibility Settings
- Check if the header row has conditional visibility set (e.g., Hidden = True based on an expression).
- Sometimes headers are hidden on certain pages due to expressions tied to parameters or page numbers.
RepeatOnNewPage Property
- In tablix or matrix reports, ensure the header row has RepeatOnNewPage = True.
- Also check KeepWithGroup settings — it should be set to After for the header row to stay with the data group.
Page Breaks
- If you have page breaks set on groups, they can sometimes cause headers to disappear if not configured correctly.
- Try removing or adjusting page breaks and see if the issue persists.
Rendering Issues
- Some rendering formats (PDF, Excel, etc.) behave differently. Try running the report in different formats to see if the issue is consistent.
Report Layout
- If the headers are part of a separate textbox or rectangle outside the tablix, they might not repeat across pages.
✅ Steps to Fix
- Open the report in Report Builder.
- Select the tablix or matrix.
- Go to the Row Groups pane.
- Right-click the static row (header), choose Properties.
- Set:
- RepeatOnNewPage = True
- KeepWithGroup = After
- Check visibility expressions and remove any that might hide the header.
- Preview the report again.
6 Replies
- wardy912
Super User
Hi mp390988
This is AI generated and unvalidated, but I hope it helps:
Possible Causes of Missing Field Headers
Visibility Settings
- Check if the header row has conditional visibility set (e.g., Hidden = True based on an expression).
- Sometimes headers are hidden on certain pages due to expressions tied to parameters or page numbers.
RepeatOnNewPage Property
- In tablix or matrix reports, ensure the header row has RepeatOnNewPage = True.
- Also check KeepWithGroup settings — it should be set to After for the header row to stay with the data group.
Page Breaks
- If you have page breaks set on groups, they can sometimes cause headers to disappear if not configured correctly.
- Try removing or adjusting page breaks and see if the issue persists.
Rendering Issues
- Some rendering formats (PDF, Excel, etc.) behave differently. Try running the report in different formats to see if the issue is consistent.
Report Layout
- If the headers are part of a separate textbox or rectangle outside the tablix, they might not repeat across pages.
✅ Steps to Fix
- Open the report in Report Builder.
- Select the tablix or matrix.
- Go to the Row Groups pane.
- Right-click the static row (header), choose Properties.
- Set:
- RepeatOnNewPage = True
- KeepWithGroup = After
- Check visibility expressions and remove any that might hide the header.
- Preview the report again.
- v-menakakota
Community Support
Hi mp390988 ,
Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank wardy912 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
Please go through the below document which may help you to resolve the issue.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team- v-menakakota
Community Support
Hi mp390988 ,
I hope the below details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support youBest Regards,
Community Support Team- v-menakakota
Community Support
Hi @mp390988 ,
I hope the below details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support youBest Regards,
Community Support Team
- Shahid12523
Community Champion
To fix missing column headers in your paginated report:
- Go to Row Groups → Advanced Mode
- Select the static header row
- Set RepeatOnNewPage = True and KeepWithGroup = After
- Make sure visibility is not hidden
- Avoid page breaks that split headers