I would like to run an SSRS report using T-SQL or similar

Alyanto
Alyanto used Ask the Experts™
on
I have a web based project and I need to kick off a report in SSRS that returns the report to a given email address  I am hoping to do this as part of a stored procedure sending the email address as a parameter.  Can this be done and how?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vitor MontalvãoMSSQL Senior Engineer
Distinguished Expert 2017

Commented:
I'm not a SSRS specialist but I think that can be done by configure the Report Server for e-mail delivery.
I have two reports that are scheduled to email particular folks. Go to the web server for your report server. Select the report and go to the management page for the report. Set up a subscription with the recipient's email address(es) and give it the date/time when to process the report. This will create a job on your SQL Server that you'll just leave alone. In my case, I render the reports in Excel format since that is what they are using. You can render to other formats as the need arises.

You will have to configure the SSRS service to be able to send email. Once that is done, subscriptions should take care of the rest.

Author

Commented:
Excelent work

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial