[Top] [All Lists]

Don't send mail if no records returned

Subject: Don't send mail if no records returned
From: "Sanjeev Rampersad"
Date: Mon, 23 Oct 2006 15:06:02 +0200
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi All,

I have the standard version of SQL Server installed.
I have setup a few reports that will be automatically sent to some out 
clients on a daily basis via a normal email-based subscription in reporting 
On some days, these reports are blank i.e. no rows returned in the dataset.
I am wondering if it is possible for the report to not be sent if a 
situation exists where the report is blank


<Prev in Thread] Current Thread [Next in Thread>