I have a main report with 9 sub reports. Each sub report is set to grow and shrink depending if there is data.
What is happening is that when there is a lot of data in one subreport, it pushes the next subreport down so that the header appears at the bottom of the page and then the detail starts on the next page.
Is there a method to keep the header and details together at all times?
I know that you can have the header row repeat but I don't want it at the bottom of one page without any detail.
I've searched and haven't found any solutions.