I'm not sure if that would help as when I do use the band, it will have variable lines to show.
However, you sparked a thought - is there any way to interact with the report object to change the height to near zero or to change the "start detail set on a new page when less than" boxes at runtime? I will know whether I need the band or not at runtime.


>Hi,
>
> Did you check/uncheck "Constant band height" for detail band?
>
>MartinaJ
>
>>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?