How to suppress entire report? 2

[jrusso]

I'd like to have Crystal not export a scheduled report at all if there is no data that meets the criteria. Does anyone know how to do that?

 

[jlp118]

You can do an if then else statement to replace that data field. Have it say If {datafield}<0, then &quot;&quot;, else {datafield}

 

[jrusso]

Thanks, but what I am trying to do is have Crystal not generate a report at all if there are no available records. For example, customer activity reports are scheduled to generate every day, but if the customer had no activity for the previous day, can Crystal not export the data? Because right now because the report is scheduled, it generates a blank Excel spreadsheet. Suppressing printing does not work for cancelling the export.

Thanks for the help! It is much appreciated.

 

[jlp118]

Have you tried to suppress if zero before you export?

 

[FoxG]

Hi jrusso

Try ticking the box in the Report Options

File...
Report Options....
Suppress printing if no records tick box

Hope this helps,

geoff

 

[jrusso]

Thanks jlp, but suppressing if zero did not work. Same with the suppress printing, but thanks for the suggestion geoff.

 

[VE]

What are you using to schedule? If you use Info, look up object dependencies in the help files, that may give you an idea. I wasn't able to set it up myself, but I think if it's possible it's in that section.

You may want to post to the Info forum as well.

good luck- and if you figure it out will you post it?

thank you
VE