February 11, 2009 at 8:37 am
Hi All,
I have a report that contains only one parameter (branch_code) which is passed in on the subscription and then the results e-mailled out.
I however cannot work out how to NOT send the e-mail when the report returns nothing. At present there are about 60 e-mails being sent, but at times, half of them are blank.
Thanks,
Danny
February 20, 2009 at 8:37 am
My proposed alternative(s) may not be the best solution...
Approach 1:
I sense you're running into a limitation. Why not setup the subscription inside the SQL database? Use DB Mail feature to email the file. It could all be done using a TSQL job. Using TSQL you can figure out whether you have null set or not.
Approach 2:
Do not change anything with subscriptions. However, setup an email alert using tsql when you find out that the end user will get blank report.
Good luck! I am curious what others would do in this situation.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply