Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andros30
Yak Posting Veteran
80 Posts |
 Posted - 2009-08-21 : 12:43:37
|
| I have a report that is emailed weekly to recipients. It is a report that returns patient information if they meet one criteria. I would like to know if it is possible to not send an email if there are no results. And where would this be set. |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-21 : 14:50:35
|
| I am only responding because I had this issue in a past life and we were instructed to purchase Enterprise Edition as it had Data Driven Subscriptions. May be a place to start (or those hallucinations and flashbacks are really getting worse...)John |
 |
|
|
andros30
Yak Posting Veteran
80 Posts |
Posted - 2009-08-21 : 16:42:44
|
| I'll have to follow up on that. I can tell you that after I deployed the report and then went to the server where the report is being hosted, I can set up a subscription for that report. However, the only thing I can do is enter emails for who is getting the report and setting up the schedule for it to run. |
|
|
|
abs_n
Starting Member
2 Posts |
Posted - 2009-08-24 : 05:19:25
|
| Yes this can be done, this is basically a data driven subscription.The data returned from your query will be sent to your recipients, if there is no data then no email will be sent.To set this up make sure your query tests the condition and also includes the relevant email address for the recipient. The report will also need a parameter, this will be a drop down list of all the recpients from the data set. When you run this report the parameter will show all the reipients which have data.When the report is ready you will need to to create a data driven subscription.I think it is a good idea to create a sample report with test data and a number of test recipients, don't use live data.At least you can test it and see how it works, hope this helps ;-) |
|
|
|
|
|
|
RS emailing