I have a report that contains both header and line-level details. In the header section, I display a few fields, and in the body, I use a tablix to show the corresponding line details.
My requirement is as follows: for example, if there is Header 1 with 4 lines and Header 2 with 5 lines, I want the report to display Header 1 with its 4 lines, then insert a page break, reset the page numbers, and continue on the next page with Header 2 and its 5 lines.
To achieve this, I added the two header fields to the line tablix and applied a page break and reset page number properties on the group. In preview mode, I can see that the page break works correctly, the page numbers reset, and the line-level data updates as expected. However, the header section continues to display the first header’s data and does not update for subsequent groups.
I have used the same expressions for these fields in both the header and the tablix. Is there a way to dynamically update the header data so that it reflects the correct group (Header 1, Header 2, etc.) on each page?

Report
All responses (
Answers (