A way to suppress the subscription is to change your stored procedure so it
returns nothing at all when there is no data. This makes your report going
into error state and suppresses the execution of the subscription.
A disadvantage is that you get the anoying message "Invalid attempt to read
when no data is present".
I 'm also looking for a better solution or a way to customize this error
message.
[quoted text, click to view] "William" wrote:
> Is there a way to suppress the execution of an email if a subscription runs a
> report that returns no data?
>
Thanks for the insight, but I have a SP that returns no data. The
subscription generates an email with results included, rendered in Excel
format. The spreadsheet has a header line, but no data. Do I need to suppress
the header to get the report to fail as you mentioned?
[quoted text, click to view] "ReneMo" wrote:
> A way to suppress the subscription is to change your stored procedure so it
> returns nothing at all when there is no data. This makes your report going
> into error state and suppresses the execution of the subscription.
>
> A disadvantage is that you get the anoying message "Invalid attempt to read
> when no data is present".
>
> I 'm also looking for a better solution or a way to customize this error
> message.
>
> "William" wrote:
>
> > Is there a way to suppress the execution of an email if a subscription runs a
> > report that returns no data?
> >
Don't see what you're looking for? Try a search.
