Don't send Email when zero records | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Don’t send Email when zero records

Is there a way not to send a subscriber Email when the report returns zero records? Thanx
Adam
hi, for a data driven subscriptions this is a pretty common thing. You will have to filter out the recipients first at the first query using e.g. an exists query / join to eliminate the not affected subscribers. For a manual subscriptions this is not possible AFAIK. HTH, Jens K. Suessmeyer. —
http://www.sqlserver2005.de

Hi Jens! [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />–<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
The button is missing on my Report Manager? I have all my reports in a project they were using a shared datasource so I switch one to use an embedded one. I still cannot see that button. I can go to data source and see a customer data source in report manager with credentials stored securly in the report. Am I missing a setting somewhere? Thanx
Adam
]]>