views:

2306

answers:

1

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!

+4  A: 

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.

cori
Thanks Cori. I found out that the Workgroup Edition license that we're using doesn't support email delivery.
Eric Ness