How to not send subscriptions when aa report has no data in MSRS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DamoSuzuki - 01 Jul 2008 06:56 GMT

Hi,

I'm having a problem where reporting services sends out e-mails with
attached repports from subscriptions even when the report has no data.
Does anyone know how to prevent e-mails being sent out if the report
has no data.

Thanks

Reply to this Message

TheRealRobbie - 01 Jul 2008 10:33 GMT

Using "Data-Driven" subscriptions you can set a query that returns recipients
for a report. You could define this query so that when no data is present,
the recipient list is also empty.

Data driven subscriptions are supported only on the enterprise edition
although you can achieve something similar on other editions: read this
article:
http://www.sqlservercentral.com/articles/Development/datadrivensubscriptions/2432/

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

DamoSuzuki - 02 Jul 2008 07:33 GMT

Thanks for that, but I dont have Enterprise edition of SQL, Is there
any way to do it with standard subscriptions

On Jul 1, 7:33 pm, TheRealRobbie
<TheRealRob...@discussions.microsoft.com> wrote:

> Using "Data-Driven" subscriptions you can set a query that returns recipients
> for a report. You could define this query so that when no data is present,
[quoted text clipped - 3 lines]
> although you can achieve something similar on other editions: read this
> article:http://www.sqlservercentral.com/articles/Development/datadrivensubscr...

Reply to this Message

TheRealRobbie - 02 Jul 2008 10:19 GMT

Sorry I wasn't clearer, but the link I included in the previous post shows
how you can achieve the same result on other editions.

http://www.sqlservercentral.com/articles/Development/datadrivensubscriptions/2432/

> Thanks for that, but I dont have Enterprise edition of SQL, Is there
> any way to do it with standard subscriptions
[quoted text clipped - 8 lines]
> > although you can achieve something similar on other editions: read this
> > article:http://www.sqlservercentral.com/articles/Development/datadrivensubscr...

Reply to this Message