Hi, Our business users would like to run reports as a batch on an ad hoc basis, instead of running them individually. They want to save a copy of the report to a library and possibly email the reports via PDF to a group. The reports have been uploaded to Sharepoint. Is this possible? Thanks Richard

Sure, all of this is possible. As I illustrate in my webinar (see my blog for details), you can use the ReportViewer control to invoke server-hosted (or local) reports programmatically, render them to PDF and send out the files as needed. I prefer this approach as I work quite a bit in code (or did) but it does require some coding. Another approach is to simply create a schedule that renders the reports. The problem is (as I see it), there is no "batch" mode. This means that you have to visit each report and request a scheduled rendering. The schedule options permit you to choose either mailed-rendering or PDF file generation. The target email can be any email address you choose. This should all be configurable through SharePoint.__________________________________________________________________ William Vaughn Author, Mentor, Trainer, MVP Beta V Corporation William Vaughn's blog Hitchhikers Guide to Visual Studio and SQL Server (7th Edition) The Owl Wrangler a fantasy fiction novel Please click the Mark as Answer button if a post solves your problem!

Setup Subscription for all these reports one for Email one for file creation. Subscriptions in turn creats jobs on SQL Agent. Call these jobs together in one single job for a adhoc setup/request.

Harshvai, I did as you suggested and that is working. I created a sql script that the business user can run to execute the SQL Agent jobs. William -- I'll check out your site with the code if It turns out I need more control over the report execution.