I am using the following code to generate a report that contains summary & detail data:

I want to summarize OB-VAL AP_VAL MIT_VAL BILLED_VAL AWARD AMT by the AWARD DOCN & then have the details (line items) below that without those summary values showing.

TABLE FILE XXXXXX
HEADING CENTER
"AW RECORDS"
"AS OF &DATE"
PRINT
AW_PA_PD_NR_ID AS 'PRE-AWARD NBR'
AW_CLIN_ID AS 'CLIN'
MM_NIIN_ID AS 'NIIN'
MM_COG_ID AS 'COG'
MM_UI_ID AS 'UI'
AW_QY AS 'AW QTY'
AW_RECEIVED_QY AS 'RCPT QTY'
QTY_DUE AS 'DUE QTY'
MM_STANDARD_UP_AM AS 'UP AM'
OB_VAL AS 'OB VAL'
AP_VAL AS 'AP VAL'
MIT_VAL AS 'MIT VAL'
CEXP AS 'BILLED VAL'
AW_ACCT_AM/P12.2C AS 'AWARD AMT' NOPRINT
BY AW_DOC_NR_ID AS 'AWARD DOCN' SUBTOTAL
ON TABLE SUBTOTAL AS ' '
ON TABLE SET SUBTOTALS ABOVE
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
ENDSTYLE
END
-RUN
This is what I am getting:

AWARD DOCN PRE-AWARD NBR CLIN NIIN COG UI AW QTY RCPT QTY DUE QTY UP AM OB VAL
58 12 46 122064.735,689,945.20
*TOTAL N0000000CM001 58 12 46 122064.73 5,689,945.20
N0000000CM001 N0000000000001 OOOOBB LLLLLLLL1 9G EA 9 9 13380.52 711,243.15
N0000000CM001 N0000000000002 OOOOBC LLLLLLLL2 9G EA 12 12 29993.04 711,243.15
N0000000CM001 N0000000000003 OOOOBD LLLLLLLL3 9G EA 12 12 33516.18 711,243.15
N0000000CM001 N0000000000004 OOOOBE LLLLLLLL4 9G EA 8 4 4 99.99 711,243.15
N0000000CM001 N0000000000005 OOOOBF LLLLLLLL5 9G EA 12 8 4 24180.00 711,243.15
N0000000CM001 N0000000000006 OOOOBG LLLLLLLL6 9G EA 1 1 8470.00 711,243.15
N0000000CM001 N0000000000007 OOOOBH LLLLLLLL7 9G EA 2 2 115.00 711,243.15
N0000000CM001 N0000000000008 OOOOBI LLLLLLLL8 9G EA 2 2 12310.00 711,243.15


This is what I want:

AWARD DOCN PRE-AWARD NBR CLIN NIIN COG UI AW Qty RCPT Qty DUE Qty UP_AM OB_VAL AP_VAL MIT_VAL BILLED VAL AWARD AMT
N0000000CM001 711,243.15 .00 2,159,821.33 5,018,896.80 7,889,961.28
N0000000000001 OOOOBB LLLLLLLL1 9G EA 9 9 13380.52
N0000000000002 OOOOBC LLLLLLLL2 9G EA 12 12 29993.04
N0000000000003 OOOOBD LLLLLLLL3 9G EA 12 12 33516.18
N0000000000004 OOOOBE LLLLLLLL4 9G EA 8 4 4 99.99
N0000000000005 OOOOBF LLLLLLLL5 9G EA 12 8 4 24180.00
N0000000000006 OOOOBG LLLLLLLL6 9G EA 1 1 8470.00
N0000000000007 OOOOBH LLLLLLLL7 9G EA 2 2 115.00
N0000000000008 OOOOBI LLLLLLLL8 9G EA 2 2 12310.00

What am I doing wrong?

This message has been edited. Last edited by: <Kathryn Henning>,

LAW,

This should do the trick:

  
-* File law01.fex
TABLE FILE CAR
SUM SALES NOPRINT 
    RCOST NOPRINT
    DCOST NOPRINT
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"<COUNTRY<SALES<RCOST<DCOST"
PRINT SALES RCOST DCOST
BY COUNTRY
BY CAR
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
 INCLUDE=ENDEFLT,
$
TYPE=SUBHEAD,
     HEADALIGN=BODY,
     JUSTIFY=RIGHT,
$
TYPE=SUBHEAD,
     ITEM=1,
     JUSTIFY=LEFT,
$
ENDSTYLE
END