Email Delivery in SSRS - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Email Delivery in SSRS

Author

Topic

shivashankara9
Starting Member

13 Posts

Posted - 2012-06-07 : 10:31:12

E-Mail Delivery in SSRS, is it possible?
What i need is: i need a way to e-mail a message to individual users or groups after subscription report that please go and check the report in portal.
In the mail i don't want to attach the report and even i don't want to attach URL Link in it, i just want to send a message to a group of users that go and check the report in portal.

Please let me know how to do this? Thank you

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-07 : 23:08:11

looks like what you need is to set up a job in sql server agent which calls sp_send_dbmail to send the message to users

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

shivashankara9
Starting Member

13 Posts

Posted - 2012-06-08 : 17:39:02

I got one more doubt

in report manager i have a report with name X

and in SQL Server Management Studio, in one of the database i have a table name with same X

in this SSMS the X database consists of 2 columns, 1 is report name and the other is user email....

earlier with this forum and with some people help i worked on Report subscription in report manager like clicked on new subscription, then selected delivery by: email, then to email id's, then attach include report or url link....all these process

I am done with this process

now what i have to do is: in this report subscription process if i am working on subscription of X report all the email id's which i have in SSMS database X table's email id's should come automatically here as i am working on same report.

So, how this gonna work?

Any idea?

Please let me know if any one knows answer for my question. Thank you Guys!!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-09 : 02:27:13

its called data driven subscriptions

http://spilich.blogspot.com/2007/11/using-data-driven-subscriptions-in.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

shivashankara9
Starting Member

13 Posts

Posted - 2012-06-09 : 14:04:49

quote:
Originally posted by visakh16

its called data driven subscriptions

http://spilich.blogspot.com/2007/11/using-data-driven-subscriptions-in.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

ohh for this do i have to work on data driven subscription?
is it is a big process to do?
Am sorry i haven't gone through the above link but i will go through with it. Thank you!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-09 : 14:25:25

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources