Prev: matrix report exported to excel
Next: dynamic page size with report viewer
From: DamoSuzuki on 1 Jul 2008 01:56
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
From: TheRealRobbie on 1 Jul 2008 05:33
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/

"DamoSuzuki" wrote:

> 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
>
From: DamoSuzuki on 2 Jul 2008 02:33
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...(a)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,
> 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/datadrivensubscr...
>
 | 
Pages: 1
Prev: matrix report exported to excel
Next: dynamic page size with report viewer