Hello,
I am wondering if there is a way to stop a report being emailed if the stored procedure contains no records. Basically, we have an hourly report that reports on errors. If an error occurs during the last stored proc call then the report displays this. However, if there are no errors, then obviously no records are brought back. We've used the Central Management Console to schedule the report every hour. But a report is being emailed to the users even though there is nothing in the Excel Spreadsheet. The users inbox is getting cluttered and also the user has to open the attachment to see if there are any records in there.
The format of the report emailed in the format of Excel (Data Only) and must remain that way due to data manipulation if there are errors. Destination is an email address. I have seen "Suppress Report if Blank" in the report options. However, this just makes the report blank but still emails it.
Thank you in advance for your help.
Regards,
Prakash