Section suppression based on unknown record count

Hello,

We are creating a number of relatively complex reports using CR 9.1.5000 (bundled with VS.NET 2003). Our project is on a really tight deadline, so we would really appreciate any help.

In most of our reports, we include a subreport or two in the report footer.

The problem is that when the reocrds of the report in the details section end at the end of a page, and the report footer overflows to the next page (because it's an expandable subreport), the page header section as well as the details section also overflow incorrectly over to the next page.

For example, say a customer has 20 orders and these 20 orders fill up a single page in the crystal report. Also assume there are some rows, say 5, of summary data given by a subreport, including complex summary data that can only be calculated in the db (the available CR functions are insufficient). The output will be as follows. Page 1 displays correctly. It shows all 20 orders on the first page. Page2 display incorrectly. It shows the subreport correctly at the top of the page, but it also shows the page header and the column lines of the details section without any data. In other words, the subreport appears ON TOP OF the empty details section on the last page.

We tried to figure out the proper formula to suppress the page header on the last page if there are no records on that page, but are unable to. Keep in mind that the height of a row is unpredictable as the text can word-wrap on the report.

Is there any way to figure out in the page header section how many records are on visible on the "current" page. Ideally, the suppress function should look something like:

PageNumber > 1 AND NumberOfRecordsOnThisPage = 0

Is this possible?

Thanks in advance!