Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Batch Reporting

Author  Topic 

rbarlow
Starting Member

26 Posts

Posted - 2008-03-11 : 12:41:06
Hey,

I was wondering if anybody knows a solution to use SQL Server Reporting Servers to batch a large number of reports. I have a simple report drawn up with a single parameter and I'm using a data driven subscription procedure (I downloaded the code off some site) to generate the report and have it emailed to the user.

Now I need to be able to batch a large number of reports, each with a different parameter. I tried to call the same data driven procedure multiple times but after a couple it chokes because I believe its trying to call the same SQL Agent Job too many times.

Has anybody has to do this before? Any help would be appreciated!

Thanks
   

- Advertisement -