Check for Records before Email

[Slapana]

I'm using Crystal Enterprise XI and have reports that are scheduled to be run and emailed. Is there a way that I can have the server check the contents of the report to make sure that there are records in it before it sends out the email? I want to try and prevent blank reports being emailed out.

Thanks!

 

[janchan]

Does someone have a solution for this? i have the same problem. we have reports to audit our batch jobs and even when there are no errors, the email is being sent. i want to restrict sending emails based on the record count or condition of some sort. is this possible?

 

[IdoMillet]

I'm no expert on how you would be able to do this in CE, but if you are willing to consider a 3rd-party solution, at least one of the Report Managers listed at:

http://www.kenhamady.com/bookmarks.html

allows you to specify that scheduled exporting/emailing/printing should be aborted if the report contains zero records.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com