May 28, 2013 at 4:31 am
How do I email a report I've created in Reporting Service 2008 R2 every month to a email address. I have configured email settings in Reporting Services Configuration Manager.
Thanks
May 28, 2013 at 6:51 am
Assuming you have at least the Standard Edition of SQL Server, all you have to do is set up a subscription in Report Manager. Choose the "email" option and give it information needed, such as the e-mail address of the recipient and the form of the report to send. If the recipient is outside of your network, probably a PDF version would be best, or you can choose a MHTML (I believe -- typing this from memory) to embed the report as the body of the message.
The subscription also allows you to specify the schedule for sending the report, so you can schedule it for once a month.
May 29, 2013 at 2:02 am
Thanks, mission accomplished 🙂 It took me a while to figure the credentials out for the data source (its needed for subscriptions)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply