Suppress Page Header and Footer if nothing to print

[krist]

Hi,

I have a question :
I have designed a report, use a selection formula based on passed parameters.
The problem is even if no records meet the selection criteria, the page header and page footer STILL PRINTS, with empty detail.
How to suppress it in this condition ?

Thanks in advance,
Krist

 

[kenhamady]

Take any required field and use it in a formula like this one, place this code in the suppress condition of the section:

IsNull ({Customer.Region}) Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[krist]

Thanks Ken,

One more thing, it still prints one blank page.
How to prevent this ?
(So that it doesn't print anything if no records meet the condition)

Thanks,
Krist

 

[kenhamady]

If you have suppressed every section using that formula, and it still kicks out a page, I am not sure where else to send you. Someone else may know the answer to that one. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[catzarecute]

It depends on how you are using/creating the report. As a VBer, I use the NoData() event in Visual Basic code and with that, I tell the user that "there is no data to print..." I then handle it accordingly (I cancel the event by setting Cancel = True and nothing prints).
=^..^=