Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Summary & Detailed Report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Summary & Detailed Report
 Login/Join
 
Member
posted
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>,
 
Posts: 14 | Registered: November 05, 2008Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Summary & Detailed Report

Copyright © 1996-2020 Information Builders