repeat row on top of new page

Question

we have report with repeating headers but this time we want the top level group which contains data to repeat on top of each page.
I have set the row group properties: KeepWithGroup = After and RepeatOnNewPage = True The tablix properties Repeat Header Rows On Each Page and Repeat Header Columns On Each Page are both checked as well.
The table header does repeat but that top level group does not.

In the image below we are trying to get the Office [Oname] row to repeat at the top of each new page.

Report Layout

Answer 1

The only way I have been able to consistently make this work is to add a page number column using a modulo of the row_number to the source dataset, and then grouping on that. This obviously requires that you make sure the number of data rows returned within each page number group will always fit on a page, which isn't always possible.