How to automate report delivery in SSRS

sql-server reporting-services reporting
Eric Ness picture Eric Ness · Nov 10, 2008 · Viewed 89.3k times · Source

I have a report in SQL Server Reporting Services (SSRS) that I'd like to schedule to run automatically as an email. I'd like the report to be attached as Excel file.
According to the Microsoft overview this should be possible.

Report delivery. SQL Server Reporting Services supports both on-demand (pull) and event-based (push) delivery of reports. Users can view reports in a Web-based format or in e-mail.

However I can't find any information on how to actually do this. Does anyone know what tools should be used or where there is a good tutorial?

Thanks!

Answer

cori picture cori · Nov 10, 2008

When you browse to the report in your reporting services site you should see a tab for Subscriptions. That's where you'd specify the recipients and delivery methods for automated delivery.

Here's a page that describes the process.

Related questions

Comments in SSRS Report Expressions

I'm using some complicated expressions in Reporting Services to control the value, format etc of data in a report (see MSDN). Is it possible to insert code comments into these expressions, and if so, what is the syntax? By code …

Read More
Sql Server Services - Overview anyone?

In Short I am thoroughly confused by the array of SQL Server services available, and am having a hard time finding a brief primer. The Scoop I am a long time ASP.Net developer who has happily been churning out …

Read More
SSRS 2008 Export to Microsoft Word does not include headers and footers

I have a report, which was recently converted from SSRS2005 to SSRS2208. The report header has a background, which is calculated depending on the page number. In the report footer there is an image and two text boxes, also calculated …

Read More