This one is driving me crazy - I have a work order with multiple detail bands. Depending upon the type of print desired (customer, internal, etc.) different table/bands may be hidden. With all except the last band (detail 5: "totals") if I set everything to hidden in the "print when" field, the information, headers, etc all disappear and the box/band below moves up to take it's space - as expected.

However, with detail band 5, it wants to allocate space to the band and spill over to the next page, essentially creating a blank page. I have removed the records from the associated table and it still wants to allocate space for the header/footer of detail band 5. The effect is that some work orders needlessly show 2 pages. I went so far as to try the report in Chen's VFP Advanced and seem to have the same problem there.

Does anyone have workaround ideas, short of making two reports for when my final band has no records and I need to hide the specific header/footer? However, it seems then detail band 4 could have the same problem, etc. - how to avoid blank pages?