Hi
I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages.
E.g.
Parent 1 - 1
Child 1 - 2
Child 2 - 3
Parent 2 - 4
Child 3 - 5
Child 4 - 6
Child 5 - 7
Originally, I was able to assign each a list item and its corresponding parent a line count and then divide that by the number of lines I can fit on one page using ROUND formula with UP. So in example above its 7 lines (count parent as one).
However, I am struggling to do this in a way I can prevent a parent group split over two pages. So for example, if I can fit a max 30 lines on a page but this would result in a parent block being split, it may be that on page 1, I only show 25 lines and move the next block to the next page.
Wondering if anyone has been able to successfully set this up?
