Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress Printing If No Records

Status
Not open for further replies.

Montana751

Programmer
Aug 14, 2001
64
US
Suppress Printing If No Records -
Select this option to suppress the printing of a report if that report does not contain any records.

What does this mean exactly? I thought the report would not print if no records exist, but my report still prints out.

Any ideas?
 
If you have some details in the report header or footer, those will show unless you suppress them. Sometimes you'd want this - know that the report was run and found nothing. If you do want nothing, you can suppress them for that report - if you set options it will apply for all reports and also may fail if someone else runs it.

To suppress a section, right-click on the section and choose Format Section. Then choose the formula icon (x+2 and a pencil) for suppression.
Test isnull({your.field})

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Suppress printing if no records means the report will show no display--just white space. If you don't have that checked, you could add a message like:

if isnull({table.recurringfield}) then
"No Records"

But in either case the report (blank or not) will still "print". I don't know how or if this option affects scheduled reports.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top