Requirements goes like this...
Would like to see a 2 reports on same EXL Sheet.If i do Compound reporting, these 2 reports are displayed on different Excel sheets.
Is there a way that i can display these 2 Tables file .. on a single EXCEL Sheets one after the another.


Example : Which wont work at all. I See only Report -1 in Excel sheet. Would like to see Report-2 on same Excel sheet.
-* Report -1
TABLE FILE CAR
PRINT *
IF COUNTRY EQ 'W GERMANY' AND CAR EQ 'AUDI'
ON TABLE SET ONLINE-FMT EXL2K
END
-*
-* Report -2
TABLE FILE CAR
PRINT *
IF COUNTRY EQ 'JAPAN' AND CAR EQ 'TOYOTA'
ON TABLE SET ONLINE-FMT EXL2K
END


Thanks you guys
-----------------------------------------------------------
WF 7.1.4 platform Windows, Databases: DB2
-----------------------------------------------------------

SET COMPOUND = OPEN NOBREAK
-RUN

TABLE FILE CAR
SUM
SALES
BY CAR
WHERE COUNTRY EQ 'W GERMANY' AND CAR EQ 'AUDI'
ON TABLE SET ONLINE-FMT EXL2K
END
-RUN

SET COMPOUND = CLOSE
-RUN

TABLE FILE CAR
SUM
SALES
BY COUNTRY
WHERE COUNTRY EQ 'JAPAN' AND CAR EQ 'TOYOTA'
ON TABLE SET ONLINE-FMT EXL2K
END
-RUN

Thank you Francis.
Sample Code works fine.