Any way to batch run a set of reports on demand?

[djmnyc]

Hi guys.

I am using Crystal Enterprise 9.0.

I have a problem I was hoping some of you have experienced yourselves, and solved in the past. I already searched the forums here, and the web, but can not find a solution.

I have a requirement to batch run a set of 20 or so reports each night after a certain DB update occurs. I solved this requirement by chaining the 20 reports together with schedule events. The schedule is kicked off when a file event is received on the crystal event server. Once this file event is received, the first report in the batch is run. Once it is complete it fires a schedule event indicating it is complete. The second report is pending, waiting for this schedule event to trigger itself to run. This is repeated until all the reports in the batch are run.

This works well for the most part ... but there are occasions where this daisy-chain process fails. When this happens, I need to manually run the reports one by one.

Is there any way I can batch run these 20 reports on demand, without using scheduling and events?

Thanks very much for your help.
Dan

 

[rhinok]

Crystal Enterprise 10 allows you to create Report Packages. You could scheduled all of these reports together as a package. You can even share parameters between reports. Lastly, an indidual report within the package may fail, but it won't cause others to fail.


~Kurt

 

[djmnyc]

Oh wow. That is great news! I will see what our license allows as far as upgrades.

Thanks!
Dan

 

[synapsevampire]

In CE 9 you might base many reports on a single Event:

APOS has a freebie CSP page which will allow you (and users) to base reports on Events, check out:

http://www.apos.on.ca/sections/07-SoftSol-Freeware.shtml

-k

 

[mdwyer]

Do the reports need to run in sequence? Why don't you just base all of them on the same file event? The Report server will limit the number of reports run concurrently according to your setting of Maximun Jobs Allowed.