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 |
|
shivashankara9
Starting Member
13 Posts |
 Posted - 2012-06-07 : 10:34:24
|
| 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 |
|
|
shivashankara9
Starting Member
13 Posts |
Posted - 2012-06-07 : 11:23:44
|
| some one please help me :) |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-07 : 11:49:39
|
| Have you done a search?Something like email from ssrs.Sounds like you know how to email a report - create a report with the message you want to run after the main report and email that.May be other ways but that's an obvious one.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
shivashankara9
Starting Member
13 Posts |
Posted - 2012-06-07 : 12:03:00
|
quote:
Originally posted by nigelrivett
Have you done a search?Something like email from ssrs.Sounds like you know how to email a report - create a report with the message you want to run after the main report and email that.May be other ways but that's an obvious one.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy.
Ya i searched this in online but i did not get the exact answer what i am looking for...when i searched in Google it shows mainly while sending email either attach report or attach URL should check compulsory.But my part is i want to uncheck both with out attaching report and URL i just want to send a message to group of people that go to portal and view report.Let me know if any one knows process for this. Thanks in adv!!! |
|
|
|
rchau861
Starting Member
5 Posts |
Posted - 2012-06-07 : 20:45:21
|
Shiva,I am no expert in SQL... to tell you the truth i suck big timebut here are my thoughts on the subjectthere’s a table in the ReportServer database called dbo.Subscriptionswith a column LastStatuscouldnt you just create a job that sends an email if the LastStatus is succeeded???? hope any of this helps..... i also am facing some problems with SSRS  |
|
|
|
|
|
|
SQL SSRS...Help Me