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 |
|
rajyar
Starting Member
1 Post |
 Posted - 2008-08-21 : 13:54:38
|
| Hi allI have started using SSRS since couple of months, came across one requirement which does e-mailing sql report.What I am trying here is, scheduling an e-mail to send a report based on results from the stored procedure. If the stored procedure that was used to build the report didn't return results, then e-mail shouldn't send report. If there is no data in the report, then user don't want to receive it in the e-mail.Can you throw some ideas to deal with this task?Thanks a bunch,Raj |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-21 : 16:59:14
|
| You can use Data-Driven Subscription for it. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Email SQL Reports based on report results