Link to home
Start Free TrialLog in
Avatar of rbnaz
rbnazFlag for United States of America

asked on

Crystal Reports No Record Returned

I have a simple crystal report to monitor if a table is being populated regularly in conjunction with Visual Cut. The report has only a report header, page header, details, and report footer. I am monitoring a date field for records. When the report returns results I want the report footer to say "VC_Skip_Email" which I can do by summarizing a field. On the other hand, if no records are returned I want my email address to show. Then Visual Cut would send me an email notification.

I've tried a variable or a summary, but the problem always returns to there being no records returned. How can I report when no records are returned?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rbnaz

ASKER

Thanks, MLMCC.