Hi Team,

Does anyone have a small code example that will create an excel spreadsheet with 2 different reports on 2 worksheets? I know how to put one report on multiple worksheets based on a By field, but 2 different reports on 2 worksheets is new to me.

TIA,

Joey
WF7.0 on Tomcat, Informix on AIX

This is an example of a compound Excel report that runs in WF 5.3.2. It creates two tabs with two reports on each tab. It's a sample provided by IBI in some documentation somewhere (I cannot recall where I found it).

TABLE FILE CAR
HEADING
"Report 1: England"
PRINT DCOST BY COUNTRY BY CAR
IF COUNTRY EQ ENGLAND
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK
ON TABLE SET STYLE *
type=report, color=red, $
type=data, backcolor=yellow, $
type=heading, color=blue, $
END


TABLE FILE CAR
HEADING
" "
" "
"Report 2: France"
PRINT RCOST BY COUNTRY
IF COUNTRY EQ FRANCE
ACROSS SEATS
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
type=report, color=lime, backcolor=fuschia, style=bold, $
type=title, color=black, style=bold+italic, $
type=heading, backcolor=black, $
END


TABLE FILE CAR
FOOTING
"Report 3 - All"
PRINT SALES BY COUNTRY BY CAR
ON TABLE PCHOLD FORMAT EXL2K NOBREAK
ON TABLE SET STYLE *
type=report, backcolor=yellow, style=bold, $
type=title, color=blue, $
type=footing, backcolor=aqua, $
END


TABLE FILE CAR
HEADING
" "
" "
"Report 4"
PRINT SALES BY COUNTRY BY CAR
ON TABLE PCHOLD FORMAT EXL2K CLOSE
ON TABLE SET STYLE *
type=report, color=yellow, backcolor=black, style=bold, $
END

Wow, this worked perfectly. Thanks a lot!