Changing the heights of pages based on dataset rows...

Hey,

I'm looking for some help on creating new pages based on the end of "datasets".

If you look at the example data, the green cells are always 5 rows but each dataset might have 1, 2, 3 or 4 green groups, so a potential of 20 rows.

I want to set the page heights based on these datasets, so in this example the end of page is by default at row 50 / row 51 which is in the middle of a dataset.

I need to move the page end to the end of the dataset + 1 so the page end would be on row 55 / row 56.
However if the end of page was on under row 43 (under half the total size of the dataset) then the new end of page would be moved up to row 32/row 33)

Thanks in advance
- Hyflex