this answer may seem kind of overly basic, but it's what comes to mind, have you tried to just make the details a subreport and have that report in...

In the properties on the General Tab there should be check boxes to allow Height to increase and decrease enable both, and make the box smaller then needed and it...

Understood, that actually works better for this case, in that it should be more like drawing names from a hat...

I actually just need to evenly split the results evenly between groups and the ROW_NUMBER() works perfectly. thank you for your help

Thank you, I knew it had to be something easy, but my brain just was drawing a blank 🙂