Scheduling multiple reports at one time

Hi,

I need my reports to run at the 4rth day of every month. I have packs of reports, and typically upto 18 reports in a pack and these packs have to run on the 4rth of every month.

How can i schedule the 18 reports to run at the same time. I don't want to schedule a time for every report ,this is very laborious.Is there any option in SSRS for simulataneously scheduling of these reports?

Thanks

Hi,

You can achieve this functionality by using a Shared Schedule.

In the case the question is if you can assign the schedule to all reports at once, the answer is not by using the web interface, but you can create an script to do so.

In the case you're asking to chain the report processing (i.e.:start report 2 when report 1 is finished), you will need to revert to a script again.

HTH,

Jordi Rambla
MVP SQL Server (Reporting Services)
Certia - rambla informàtica (http://www.certia.net)
Solid Quality Learning (http://www.solidqualitylearning.com)

sql