Hi All,
I've written reports and deployed them with data-driven subcriptions. I
have a new requirement and would like to know if there is a solution I
can impliment to conditionally send an email to a recipient "ONLY" if
the report to this specific recipient contains data. If I'm correct,
the data-driven query will send an email to each in the result set of
the query whether the report contains data or not.
Am I on the right track and is this possible?
Thank in advance!
Kind regards - FredHi Igor,
> One solution would be if you can implement your data-driven (DD) query in a
> way that returns a user only if data for this user exists. Alternative is
> writing a custom delivery - then you have a complete control over the send
> logic. Otherwise you're right: email is sent to each in the result set of
> the DD query whether the report contains data or not.
I'll most liekly go with the DD query up front as a better solution.
Just wanted to see if there was something I'm missing. Thanks for your
input.
Regards - Fred
Thursday, March 22, 2012
Conditionally Send Email Subscription
Labels:
conditionally,
data-driven,
database,
deployed,
email,
microsoft,
mysql,
oracle,
reports,
requirement,
server,
sql,
subcriptions,
subscription,
written
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment