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>,
January 27, 2014, 12:28 PM
Danny-SRL
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
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF