I have a report where the logic hides (does not display) the subreports if there is no data in them. They are set to shrink and grow, but the problem is that i guess it still takes up room on the page and spits out a blank page at the end of each grouping if it is close to rolling over a page. Does anyone know how to have it not print the page if it has hidden data on it and is blank? Thanks in advance for any help.
do you mean you are just wasting a single line of space or so?
how much blank space is there?
do you have "new page after group" set to true? Is that happening very occasionally. You get a blank subreport causing a page throw, and then you get your real new page.
The trouble is that what a report does is this: prints the header and footer, and then uses the remaining space for detailed records. If there isn't enough room for a given detailed record it advances to a new page. It's quite hard to control what a print does at an atomic level. you have "keep together", "force new page", and so on, but it's hard to completely control what happens at the bottom of a page.
if you want absolute precision, then maybe the alternative is to iterate a recordset, design the report as a text file, with fixed width strings, and count 66 lines per page. You won't get graphics though, just text.