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     That dreaded two-line SUBTOTAL again!

Read-Only Read-Only Topic
Go
Search
Notify
Tools
That dreaded two-line SUBTOTAL again!
 Login/Join
 
Francis Mariani
Expert
posted 
DEFINE FILE CAR
DUMMY1/A50 ='';
WB1/D7 = IF WHEELBASE LT 95 THEN SALES ELSE 0;
WB2/D7 = IF WHEELBASE FROM 95 TO 104 THEN SALES ELSE 0;
WB3/D7 = IF WHEELBASE GT 104 THEN SALES ELSE 0;
FLAG1/A1 = '';
END

TABLE FILE CAR
SUM
WB1
WB2
WB3
BY COUNTRY NOPRINT
BY DEALER_COST NOPRINT
BY DUMMY1 NOPRINT
BY SEATS AS ''

SUM
FLAG1 NOPRINT
SALES
BY COUNTRY NOPRINT
BY DEALER_COST NOPRINT
BY DUMMY1 NOPRINT
BY SEATS AS ''

ACROSS WHEELBASE

ON DUMMY1 SUBTOTAL AS 'SUBTOTAL'

ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=WB1, SEQUENCE=95, $
ENDSTYLE
END


The SUBTOTAL is displayed on two lines.

Remove the style sheet entry for column WB1 and the SUBTOTAL is displayed on one line.

Why on earth does this happen?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
hammo1j
Master
posted Hide Post
Francis

I'm curious - how does the SEQUENCE in the style sheet work - I've never seen it before.

Regards

John


Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
susannah
Expert
posted Hide Post
neither had i, so i looked it up:
"This request rearranges the order in which columns normally appear in the report, that is, with SNAME first, PRODCAT second, and LINEPRICE third.
TABLE FILE CENTORD
SUM LINEPRICE AS 'Sales'
BY SNAME BY PRODCAT AS 'Product'
WHERE SNAME EQ 'eMart' OR 'City Video'
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=SNAME, SEQUENCE=3, $
TYPE=REPORT, COLUMN=PRODCAT, SEQUENCE=2, $
TYPE=REPORT, COLUMN=LINEPRICE, SEQUENCE=1, $
ENDSTYLE
END



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Francis Mariani
Expert
posted Hide Post
I find it very handy with ACROSS and multi-verb requests.

Here's an example:

DEFINE FILE CAR
SALESD/D7S = SALES;
SALES_EU/D7S = IF COUNTRY IN ('ENGLAND', 'FRANCE', 'ITALY', 'W GERMANY') THEN SALES ELSE 0;
END
TABLE FILE CAR
SUM SALES_EU
BY SEATS
SUM
SALESD AS ''
BY SEATS
ACROSS COUNTRY

HEADING
"WEBFOCUS REPORT"
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLESHEET *
BORDER=1, BORDER-COLOR=SILVER,
FONT='ARIAL', SIZE=8, $
TYPE=REPORT, COLUMN=SALES_EU, SEQUENCE=99, $
END


The total for Europe, which is calculated in the first SUM is actually displayed as the last column.

UNFORTUNATELY, SEQUENCE MUCKS UP THE STYLE SHEET FOR EXCEL and MUCKS UP THE SUB TOTAL LINE.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Tony A
Expert
posted Hide Post
De ja vu?


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
<JJI>
posted
Hi,

Why all the scourge with the sequence if you can use a simple ACROSS_TOTAL
This ex. works just fine for me!

DEFINE FILE CAR
SALESD/D7S = SALES;
SALES_EU/D7S = IF COUNTRY IN ('ENGLAND', 'FRANCE', 'ITALY', 'W GERMANY') THEN SALES ELSE 0;
BLANK/A1 WITH SEATS = ' ';
END
TABLE FILE CAR
-*SUM SALES_EU
-*BY SEATS
SUM
SALESD AS ''
BY SEATS
BY BLANK NOPRINT
ACROSS COUNTRY
ACROSS-TOTAL AS 'TOTAL'
ON TABLE SUBTOTAL
HEADING
"WEBFOCUS REPORT"
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLESHEET *
BORDER=1, BORDER-COLOR=SILVER,
FONT='ARIAL', SIZE=8, $
-*TYPE=REPORT, COLUMN=SALES_EU, SEQUENCE=99, $
END

Even with a subtotal and the styling is not mucked up!

Hope this helps,

Dirk JJI
 
Report This Post
<JJI>
posted
must be ACROSS-TOTAL !!!!!!

Sorry for the typo :-(

Dirk JJI
 
Report This Post
Francis Mariani
Expert
posted Hide Post
Because I don't want an ACROSS-TOTAL, I want a subtotal of SOME of the columns, not ALL of the columns. The only way I can do this is with a multi-verb request.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report 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     That dreaded two-line SUBTOTAL again!

Copyright © 1996-2020 Information Builders