all groups > sql server reporting services > november 2006 >
You're in the

sql server reporting services

group:

Dont send empty squeduled emails.


Dont send empty squeduled emails. Mikael
11/20/2006 6:23:02 AM
sql server reporting services:
Hi

I need to squedule the sending of a report.
My customers does not want empty reports.
How can I cancel the sending of the squduled report if the result has no
rows ?

I found this but dont think it is pretty:

http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6d60055b22dbc4d6/cab5eb50a63735fa?lnk=st&q=%22Reporting+Services%22+dont+send+email&rnum=28#cab5eb50a63735fa

Any idears ?

--
Best regards

Re: Dont send empty squeduled emails. Chris Conner
11/20/2006 2:25:23 PM
Yes, use a data-driven subscription.

Are you using Standard or Enterprise version of Reporting Services?

=-Chris

[quoted text, click to view]

Re: Dont send empty squeduled emails. Mikael
11/20/2006 11:53:02 PM
Hi

We are using a standard version of Reporting Services.
Also we query a SQL2000 server for data.

Can a data-driven sunscription also be "Squedulet" so the cursomers recive
the report at a specific time ?

--
Best regards

Mikael


[quoted text, click to view]
Re: Dont send empty squeduled emails. Chris Conner
11/21/2006 10:23:30 AM
The standard edition does not support data-driven subscriptions. :(

You will have to come up with another way to do it.

=-Chris


[quoted text, click to view]

Re: Dont send empty squeduled emails. Mikael
11/22/2006 2:32:02 AM
Thank you for trying :)

So I need to cancel the sending of a report it the result of the report is
emty.

Any idears ?

--
Best regards

Mikael


[quoted text, click to view]
AddThis Social Bookmark Button