Solved

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

Posted on 2014-12-02
3
336 Views
Last Modified: 2014-12-10
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?
0
Comment
Question by:Alyanto
3 Comments
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
I'm not a SSRS specialist but I think that can be done by configure the Report Server for e-mail delivery.
0
 
LVL 4

Accepted Solution

by:
jimtpowers earned 500 total points
Comment Utility
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.
0
 

Author Closing Comment

by:Alyanto
Comment Utility
Excelent work
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now