Using BYTOC for EXCEL 2000

[LeonelSanchezJr]

I realize that BYTOC can be used to create separate workbooks within 1 excel sheet, but here's the trick I have to do.

I have a Report Caster Job that needs to BURST by ORIGIN.
I also need to do a BYTOC by SHIPMENTTYPE.

When I do this, the BYTOC creates separate tabs in Excel by ORIGIN instead of by SHIPMENTTYPE.

How can I do a BYTOC on my 2nd BY field?

Thanks,

Leo ;-)

 

[oceannative]

Hi Leo,

BYTOC will only work on the first BY field, same as Caster...

Anyone know a work-around in this situation?

oceannative