Multiple sheet COMT output. Is it possible...

[Don Robison]

Multiple sheet COMT output. Is it possible

[NYCBabak .]

COMT is a text file you can open in notepad so my SWAG is that it is not.

[David Briars]

The WebFOCUS Excel Table of Contents (BYTOC) feature enables you to generate a multiple worksheet report in which a separate worksheet is generated for each value of the first BY field in the report.

 

TABLE FILE CAR

"Sales for <COUNTRY"

SUM SALES/I9C

BY COUNTRY

BY CAR

ON TABLE PCHOLD AS CAR_SALES FORMAT XLSX BYTOC

ON TABLE SET STYLE *

INCLUDE=IBFS:/WFC/Repository/afolder/code/stylesheets/jellybean_combo.sty, $

ENDSTYLE

END