Scheduled Reports as Attachment - Do not send if blank

Kristy Factor

Is it possible to stop a scheduled report attachment from sending if the report has 0 results? Our recipients can start to ignore the reports because half the time they receive it, it is blank. So if they don't look at it because they think it is blank half the time, they miss the important report when it may actually have some items within the report to review.

Kristy Factor

Or even better idea would be an option to still be able to send the email, but be able to input a different message when the report is blank. So when the report has results, send an email with specified message with attachment and if the report is blank send an email with a different specified message. This way the recipients aren't confused if they receive nothing and the scheduled message will populate with our blank report message option we input. That way I could have one that says "See attached report…." and one that "No items to review this week…" or whatever the customized message might be.