Thursday, August 14, 2008

Automatic Report Delivery

Does anyone know of the best way to automatically export different SSRS reports to a single PDF file on a daily basis?

Question from the SQL Server Reporting Services Forum


For all of you that would like to get a report delivered automatically to you by e-mail, then this tip is for you. In SQL Reporting Services, you can subscribe to a report.

All you've got to do is navigate to the report you want to review in Report Manager, and then click the Subscription button and fill out the details. It's that easy.