Scheduling reports to run

Is there a way to schedule reports to run on a specif day and time and save them to excel files?

Hello John,

Yes, of course you can.

Open Report Manager. (http://ServerName/Reports) and drill down to your report you want to schedule. Click on the Properties tab from the tob and the Data Sources tab from the left. Verify that you connection is correct and select 'Credentials stored securely in the report server' and give it an account to run the report. Then go to the Subscriptions tab from the top and hit 'New Subscription'. If you want to save to Excel, then select 'Report Server File Share' and set your options. Down at the bottom, you can set the schedule of the report.

Hope this helps.

Jarret

|||Thanks, Jarret. That's easy enough.sql