Here's what I currently do. I have 2 report caster jobs (one creates summary reports and the other creates detail reports) for capital projects. The reports are then burst out via email to project managers. If a project manager has 10 projects, currently they will receive 2 emails - one with 10 summary reports attached and one will 10 detail reports attached.

We would like to find a way to create a single compound report with summary and detail for each project and then burst the output to the project managers.

It seems like you'd need to create a loop that runs the summary report and the detail report for the first project then loops back and runs the summary and detail reports for the 2nd project, etc....until all the projects are run.

Any ideas???

Bethany

Server Environment:
Win2K3 Server
WebFOCUS 7.13
DevStudio 7.14
Apache Tomcat standalone application server

The easy, flip answer is to upgrade to 76 which has the PDF Layout Painter.

But all silliness aside, write a short report which produces a SAVE file with all the distinct projects. Then you can use this as a WHERE in your loop. But as I write this, I realize that this will not work in Report Caster which only distributes the last report run.

Another idea is to combine the summary and detail reports into one, possibly using MacGyver technique such that you would be creating a single report (more efficient against the backend data source as well) that you could then burst and distribute with RC.

Bethany
We do something similar.
We created a compound report per account team. The report has data tables and graphs per team. The report works very well but the monthly bursting was a challenge. The basic bursting was not an option.
What we did is use the function "prereport" this prereport runs and prepares the settings we need for the compound report.

In the prereport we create an little file with a sequence number and the teamnames.
At the start we first test if the file exists and if it is from this day. If that is the case we read the first line and use that to create some amper variables.
The real looping is not managed. What we do is create 10 lines in the Reportcaster process each with a time split of 2 minutes. It runs on the first day of the month.
It can be done this way since we know there are only 10 teams.

I hope this helps a bit