Groups | Blog | Home
all groups > sql server notification services > october 2006 >

sql server notification services : Don't send mail if no records returned


Sanjeev Rampersad
10/23/2006 3:06:02 PM
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
services.
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

Thanks
Sanjeev

Joe Webb
10/31/2006 12:00:00 AM
You'll likely have responses if you post in the reporting services
news group rather than the notification services news group. SSRS
doesn't use SSNS as its notification engine.

HTH...

Joe


--
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)


On Mon, 23 Oct 2006 15:06:02 +0200, "Sanjeev Rampersad"
[quoted text, click to view]
Sanjeev Rampersad
11/3/2006 12:00:00 AM
Thanks Joe.
[quoted text, click to view]

AddThis Social Bookmark Button