All,

I am looking for the best way to handle the following, we have a need for a report to show up much like the following:

COUNTRY SUM of RCOST, other measures
CAR SUM of RCOST, other measures
MODEL SUM of RCOST, other measures

The MODEL lines would repeat for each car, and the CAR would repeat for each COUNTRY, and we do want them on separate lines.

Anybody with an idea of how I could handle this best?

This message has been edited. Last edited by: DW Marker,

Try something along these lines

 
TABLE FILE CAR
SUM COUNTRY/A50 AS 'COL1'
    RCOST
 DCOST
COMPUTE ORDERA/I5= IF COUNTRY NE LAST COUNTRY THEN LAST ORDERA + 1 ELSE LAST ORDERA;
COMPUTE ORDERB/I5= 0;
COMPUTE ORDERC /I5= 0;
BY COUNTRY NOPRINT
ON TABLE SET ASNAMES ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS DATA FORMAT ALPHA
END
-RUN
FILEDEF DATA DISK DATA.FTM (APPEND
-RUN
TABLE FILE CAR
SUM  COMPUTE COL1/A50= '  ' | CAR;
    RCOST
 DCOST
COMPUTE ORDERA/I5= IF COUNTRY NE LAST COUNTRY THEN LAST ORDERA + 1 ELSE LAST ORDERA;
COMPUTE ORDERB/I5= IF CAR NE LAST CAR THEN LAST ORDERB + 1 ELSE LAST ORDERB;
COMPUTE ORDERC /I5= 0;
BY COUNTRY NOPRINT
BY CAR NOPRINT
ON TABLE SET ASNAMES ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE AS DATA FORMAT ALPHA
END
-RUN
TABLE FILE CAR
SUM COMPUTE COL1/A50= '    ' | MODEL;
    RCOST
 DCOST
COMPUTE ORDERA/I5= IF COUNTRY NE LAST COUNTRY THEN LAST ORDERA + 1 ELSE LAST ORDERA;
COMPUTE ORDERB/I5= IF CAR NE LAST CAR THEN LAST ORDERB + 1 ELSE LAST ORDERB;
COMPUTE ORDERC/I5= IF MODEL NE LAST MODEL THEN LAST ORDERC + 1 ELSE LAST ORDERC;
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL NOPRINT
ON TABLE SET ASNAMES ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE AS DATA FORMAT ALPHA
END
-RUN
TABLE FILE DATA
PRINT RETAIL_COST DEALER_COST
BY ORDERA NOPRINT
BY ORDERB NOPRINT
BY ORDERC NOPRINT
BY COL1
ON TABLE SET SHOWBLANKS ON
END

 

Thanks a bunch JG, that is exactly what I needed... I was on the right trsck but was stumbling over how to use the counters to get what I needed... I am sure after a few more hours of banging my head it would have appeared to me.