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 |
|
raj.prabhu001
Starting Member
16 Posts |
 Posted - 2011-10-12 : 04:53:48
|
| Hi,I have a requirement in which First--> A report is generated based on Stored Procedure2nd---> format of report is as belowdocnum----customername----Emailid12 ---- shanti --- abc@gmail.com13 ---- udoys --- adj@gmail.comNow---> Based on this report mail should be sent to only customer listed in the report to their Respective Email AddressPlease let me know how to do this in SSRS. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-10-12 : 05:03:12
|
| Why do you need to do this in SSRS? Just run the proc and use the email column and send whatever message you have to send with db mail.. |
 |
|
|
raj.prabhu001
Starting Member
16 Posts |
Posted - 2011-10-12 : 06:21:00
|
| i need to do it in SSRS only pleas help |
|
|
|
rajarajan
Starting Member
48 Posts |
Posted - 2011-10-12 : 10:29:06
|
| raj : u can create link report for the base report so u will get the 2 reports one report for one SP and another one in the linked report u can have subscription . hope this will help or let me know . |
|
|
|
raj.prabhu001
Starting Member
16 Posts |
Posted - 2011-10-13 : 01:17:09
|
| no i dont need two reports single is needed for subscription and mailing |
|
|
|
rajarajan
Starting Member
48 Posts |
Posted - 2012-03-14 : 12:41:10
|
| u can write the coustom DLL and input is report name and using the DLL u can send mail Soory very late reply . hope u have fix the issue |
|
|
|
|
|
|
SSRS- Subscription -Problem