Does anyone have a technique to create a Caster routine which will burst (on 1st BY), but then also spilt a report into separate tabs (on the 2nd BY)?

Here's an CAR example, but it doesn't work the way I want:

TABLE FILE CAR
PRINT COUNTRY
MODEL
BODYTYPE
SEATS
DEALER_COST
RETAIL_COST
SALES
BY COUNTRY NOPRINT
BY CAR
ON TABLE PCHOLD FORMAT EXL2K BYTOC
END

I thought the NOPRINT on COUNTRY would force WebFocus to then to do the BYTOC on CAR. I want Caster to burst separate reports for COUNTRY, but then within a given COUNTRY report/file, have each CAR on a separate tab in the excel output.

Any recommendations would be appreciated.

Thanks!

This message has been edited. Last edited by: Kerry,

Concatenate the columns and sort on that?

Ginny -- thanks for the suggestion.

I think what you are suggesting would make the Caster job burst more files than I want, and still not give me the tabbing I'm looking for.

From the RC Administration Manual:

Note:
❏ The size of a TOC-enabled report is limited to the memory available on the WebFOCUS
Client.
❏ Bursting a TOC-enabled report using ReportCaster is not supported.
❏ The controlling multiple reports feature, documented in Controlling Multiple Reports in
the Enhancing the User Interface chapter in the Developing Reporting Applications with
Graphical Tools manual, is not supported by ReportCaster.

There might be some work around such as what Ginny suggests or running a report to determine a list of first-level values and the running the report multiple times in a loop, once for each value, or possibly some iteration of the MacGuyver technique (there's good problem for somebody!)

But as standard functionality, it think you're not going to get what you want.

Darin,

Thanks for your assistance, I appreciate it -- at least I know now where I stand and that this isn't presently supported functionality.

TV