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] GAP BETWEEN MORE FILE OUTPUT AND GRAND TOTAL FOR EACH FILE

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] GAP BETWEEN MORE FILE OUTPUT AND GRAND TOTAL FOR EACH FILE
 Login/Join
 
Gold member
posted
Hello,
I got the below request, I appreciate any one have suggestion...

 
TABLE FILE CAR
PRINT CAR SALES
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS HOLD1 FORMAT FOCUS
END
-*====================================
TABLE FILE CAR
PRINT CAR SALES
BY COUNTRY
WHERE COUNTRY EQ 'JAPAN';
ON TABLE HOLD AS HOLD2 FORMAT FOCUS
END
-*====================================
TABLE FILE HOLD1
PRINT CAR SALES
BY COUNTRY
ON TABLE HOLD AS HOLD3
MORE
FILE HOLD2
END
-*====================================
TABLE FILE HOLD3
PRINT *
END


CURRENT OUTPUT
COUNTRY CAR SALES
ENGLAND JAGUAR 0
ENGLAND JAGUAR 12000
ENGLAND JENSEN 0
ENGLAND TRIUMPH 0
JAPAN DATSUN 43000
JAPAN TOYOTA 35030
======================
TOTAL 90030
======================


USER WANTS THE OUTPUT GAP AND GRAND TOTAL BETWEEN FILE JUST LIKE BELOW EXAMPLE
COUNTRY CAR SALES
ENGLAND JAGUAR 0
ENGLAND JAGUAR 12000
ENGLAND JENSEN 0
ENGLAND TRIUMPH 0
=====================
TOTAL 12000
=====================
JAPAN DATSUN 43000
JAPAN TOYOTA 35030
====================
TOTAL 78030
====================

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
 
Posts: 73 | Registered: April 06, 2016Report This Post
Platinum Member
posted Hide Post
TABLE FILE HOLD3
PRINT SALES
BY COUNTRY
BY CAR
ON COUNTRY SUBFOOT
"========================"
"TOTAL <ST.SALES "
"========================"
ON TABLE SET BYDISPLAY ON
END  


WebFocus 8.201M, Windows, App Studio
 
Posts: 227 | Location: Lincoln Nebraska | Registered: August 12, 2008Report This Post
Virtuoso
posted Hide Post
Simple as this
TABLE FILE CAR
PRINT CAR SALES
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS HOLD1 FORMAT FOCUS
END
-*====================================
TABLE FILE CAR
PRINT CAR SALES
BY COUNTRY
WHERE COUNTRY EQ 'JAPAN';
ON TABLE HOLD AS HOLD2 FORMAT FOCUS
END
-*====================================
TABLE FILE HOLD1
PRINT CAR SALES
BY COUNTRY
ON TABLE HOLD AS HOLD3
MORE
FILE HOLD2
END
-*====================================
TABLE FILE HOLD3
SUM SALES
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL
ON TABLE NOTOTAL
ON TABLE SET BYDISPLAY ON
END

Then play with formatting (styling) as you wish.

Or even simplest depending if you really need to create HOLD file to then MORE them
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL

WHERE COUNTRY EQ 'ENGLAND' OR 'JAPAN';

ON TABLE NOTOTAL
ON TABLE SET BYDISPLAY ON
END

But if you need to create blank rows, jfr99 sample may be an option.

More fancy way to avoid blank line at the end
TABLE FILE CAR
SUM SALES
BY TOTAL COMPUTE ROWID /I1 = IF COUNTRY EQ LAST COUNTRY THEN ROWID ELSE ROWID + 1; NOPRINT
BY COUNTRY
BY CAR

ON COUNTRY SUBFOOT
""
"Total <ST.SALES"

ON ROWID SUBHEAD
""
WHEN ROWID NE 1;

WHERE COUNTRY EQ 'ENGLAND' OR 'JAPAN';
ON TABLE NOTOTAL
ON TABLE SET BYDISPLAY ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END

This message has been edited. Last edited by: MartinY,


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Gold member
posted Hide Post
Thanks both of you, In my report I used file more option ,I don't want to upload all the code that is why I showed as CAR file Example.

After I posted , I added the breakpoint to my report its working. But only the HEADING is repeating every breakpoint....
This is the added to my report..
COMPUTE LINE/I4 WITH E01= IF LINE EQ 6 THEN 1 ELSE LINE+1; NOPRINT
COMPUTE BREAKPOINT/I4 = IF ((LINE EQ 6)) THEN BREAKPOINT+1 ELSE BREAKPOINT; NOPRINT

BY BREAKPOINT NOPRINT
ON BREAKPOINT PAGE-BREAK
ON BREAKPOINT SUB-TOTAL


HEADING
" <+0>&StartYear and January 1, &Year through <EndDate"
""
""
""
ON TABLE SUBFOOT
""
""

  


WebFOCUS 8
Windows, All Outputs
 
Posts: 73 | Registered: April 06, 2016Report 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] GAP BETWEEN MORE FILE OUTPUT AND GRAND TOTAL FOR EACH FILE

Copyright © 1996-2020 Information Builders