Suppressing Blank pages

[randallJ]

Is there a way to suppress a page in a report if it is blank.

For example I have put print when conditions on fields in a multiple page report, If the conditions are not met a blank page is printed, is there a way of telling it " do not print page if blank

 

[bborissov]

No, but you could make all obejcts to be Float and mark Remove Line if blank.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[randallJ]

thanks boris but that did not work.

 

[bborissov]

No way. In all my reports I have that and I have no empty pages at all.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[randallJ]

Really?? Does it matter where the objects are i.e. detail, header or footer.

 

[bborissov]

Yes, all my object are float and checked Remove Line if blank.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[bborissov]

O, BTW check to see if you set Constant Band height for some band(s), If so Unmark this.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[randallJ]

I have checked Constant Band Height and it is not checked. If the objects are not blank then I need them printed on a new page and as such have specified new page with group change. Could this be why it does not work.

 

[DSummZZZ]

Or you could always check the values before trying to print them.

Something like:

REPORT FORM FOR nSomeNumber > 0 .AND. ;
                nSky = 'BLUE' .AND. ;
                ...

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[bborissov]

I it hard to me to say why this happens, If you wish you could send me the report with some simple data to borisb AT microcomplex DOT com

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP