FILEDEF HDATA DISK HDATA.DAT (APPEND

SET PAGE-NUM = OFF

DEFINE FILE CAR
LABEL/A20 = 'AMOUNT1';
AMOUNT/D7 = DEALER_COST;
END

TABLE FILE CAR
PRINT 
LABEL
AMOUNT
BY CAR
BY MODEL
ON TABLE HOLD AS HDATA FORMAT ALPHA
END

DEFINE FILE CAR
LABEL/A20 = 'AMOUNT2';
AMOUNT/D7 = RETAIL_COST;
END

TABLE FILE CAR
PRINT 
LABEL
AMOUNT
BY CAR
BY MODEL
ON TABLE HOLD AS HDATA FORMAT ALPHA
END

TABLE FILE HDATA
PRINT 
AMOUNT AS ''
BY CAR NOPRINT
BY MODEL NOPRINT
BY LABEL AS ''

ON MODEL SUBHEAD
" <CAR : <MODEL "

END

  
TABLE FILE CAR
PRINT DEALER_COST AS 'Dealer Cost'
 OVER RETAIL_COST AS 'Retail Cost'
 OVER SEATS       AS 'Seats'
 OVER LENGTH      AS 'Length'
 OVER WIDTH       AS 'Width'
 OVER HEIGHT      AS 'Height'
 OVER WEIGHT      AS 'Weight'
 OVER WHEELBASE   AS 'Wheel Base'
 OVER FUEL_CAP    AS 'Fuel Cap'
 OVER BHP         AS 'Brake Horse Power'
 OVER RPM         AS 'Revs/Minute'
 OVER MPG         AS 'Miles/Gallon'
BY MODEL NOPRINT 
ON MODEL SUBHEAD
" "
"<MODEL>"
END
-RUN