SET COMPOUND=BYTOC

TABLE FILE CAR
PRINT
RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE HOLD
END

TABLEF FILE HOLD
PRINT
RETAIL_COST
BY CAR SUBTOTAL
BY MODEL
HEADING
"Car...<COUNTRY> <CAR> "
ON TABLE PCHOLD FORMAT EXL2K
END

 
SET COMPOUND=BYTOC
DEFINE FILE CAR
-* Note you can define the field as any length you like but Excel will only use the 1st 31 characters
-* for the tab name (Excel limit) may be an issue because tab names must be unique.
PAGESORT/A50= COUNTRY || ' ' | CAR ;
END
TABLE FILE CAR
PRINT
RETAIL_COST
BY PAGESORT NOPRINT
BY COUNTRY
BY CAR
HEADING
"Hi Car... "
ON TABLE PCHOLD FORMAT EXL2K
END