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     [CLOSED]Subhead missing when adding SET PRINTPLUS =ON

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Subhead missing when adding SET PRINTPLUS =ON
 Login/Join
 
Sangeetha Durairaju
Member
posted
Hi,

I have a ON TABLE SUBFOOT and ON TABLE FOOTING in my FEX. When I run the FEX, the footing comes before the subfoot. but I want the Vice versa. The footing should be in the Bottom and it should come after subfoot. So to put it in order, I added SET PRINTPLUS =ON. This worked but it removed the Subhead.

I need the Subhead as it is. Then the Subfoots and the last should be the footing content. Please see the sample code here.

Can someone please help.

========================================
-*SET PRINTPLUS = ON

TABLE FILE CAR
SUM
CAR.BODY.SALES
CAR.BODY.DEALER_COST
BY CAR.ORIGIN.COUNTRY NOPRINT
BY CAR.COMP.CAR
BY CAR.BODY.SEATS
BY CAR.CARREC.MODEL

ON CAR.ORIGIN.COUNTRY SUBHEAD
"ON CAR.ORIGIN.COUNTRY SUBFOOT MULTILINES
"
ON CAR.COMP.CAR SUBFOOT MULTILINES
" ON TABLE SUBFOOT
"Total:<+0> <+0> ON TABLE FOOTING
"* Footing - should be at the end."

WHERE CAR NE 'AUDI'
ON TABLE SET AUTOFIT ON
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR='WHITE',
TOPGAP=0.055556,
BOTTOMGAP=0.055556,
$
TYPE=DATA,
COLUMN=N2,
TOPGAP=0.055556,
BOTTOMGAP=0.055556,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N6,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N5,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
JUSTIFY=CENTER,
$
TYPE=TITLE,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='BLACK',
BACKCOLOR='SILVER',
STYLE=-UNDERLINE+BOLD,
TOPGAP=0.055556,
BOTTOMGAP=0.055556,
JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
HEADALIGN=BODY,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=SUBHEAD,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='WHITE',
BACKCOLOR=RGB(85 85 85),
STYLE=BOLD,
TOPGAP=0.055556,
BOTTOMGAP=0.055556,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(235 237 239),
STYLE=BOLD,
TOPGAP=0.055556,
BOTTOMGAP=0.055556,
HEADALIGN=BODY,
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=3,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
BY=2,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BY=2,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BY=2,
OBJECT=FIELD,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
BY=2,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BY=2,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
BY=2,
LINE=1,
OBJECT=FIELD,
ITEM=3,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=2.000000,
$
ENDSTYLE
END

=================================================
Thanks,
Sangeetha

This message has been edited. Last edited by: <Emily McAllister>,


Webfocus 8.1.05
 
Posts: 4 | Registered: June 07, 2016Report This Post
Francis Mariani
Expert
posted Hide Post
Please ALWAYS put your code between code tags (that's what the </> button is for), otherwise your headings/footing get messed up because they contain less-than signs that are assumed to be HTML. 

[code]
your code here
[/code]


The Report Footing (ON TABLE SUBFOOT) is always the last element on the page.

This message has been edited. Last edited by: Francis Mariani,


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
Sangeetha Durairaju
Member
posted Hide Post
Hi Francis,
Sure. Please find my code below:

{Code begins}

-*SET PRINTPLUS = ON
DEFINE FILE CAR
X/A1='';
END
TABLE FILE CAR
SUM
CAR.BODY.SALES
CAR.BODY.DEALER_COST
BY X NOPRINT
BY CAR.ORIGIN.COUNTRY NOPRINT
BY CAR.COMP.CAR
BY CAR.BODY.SEATS
BY CAR.CARREC.MODEL

ON CAR.ORIGIN.COUNTRY SUBHEAD
"subhead countryON CAR.ORIGIN.COUNTRY SUBFOOT MULTILINES
"subfoot country
ON CAR.COMP.CAR SUBFOOT MULTILINES
"subfoot car ON X SUBFOOT
"Total:<+0> <+0>
ON TABLE SUBFOOT
-*"Total:<+0> <+0> "* Footing - should be at the end."
WHERE CAR NE 'AUDI'
ON TABLE SET AUTOFIT ON
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR='WHITE',
TOPGAP=0.055556,
BOTTOMGAP=0.055556,
$
TYPE=DATA,
COLUMN=N2,
TOPGAP=0.055556,
BOTTOMGAP=0.055556,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N6,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N5,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
JUSTIFY=CENTER,
$
TYPE=TITLE,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='BLACK',
BACKCOLOR='SILVER',
STYLE=-UNDERLINE+BOLD,
TOPGAP=0.055556,
BOTTOMGAP=0.055556,
JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
HEADALIGN=BODY,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=SUBHEAD,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
COLOR='WHITE',
BACKCOLOR=RGB(85 85 85),
STYLE=BOLD,
TOPGAP=0.055556,
BOTTOMGAP=0.055556,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(235 237 239),
STYLE=BOLD,
TOPGAP=0.055556,
BOTTOMGAP=0.055556,
HEADALIGN=BODY,
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=3,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
BY=2,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BY=2,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BY=2,
OBJECT=FIELD,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
BY=2,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
BY=2,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
BY=2,
LINE=1,
OBJECT=FIELD,
ITEM=3,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=2.000000,
$
ENDSTYLE
END

{Code Ends}


Webfocus 8.1.05
 
Posts: 4 | Registered: June 07, 2016Report This Post
Francis Mariani
Expert
posted Hide Post
From the documentation: "SET PRINTPLUS=ON Handles page breaks internally to provide the correct spacing of pages. You can perform RECAPs in cases where pre-specified conditions are met. Additionally, a SUBFOOT prints above the footing instead of below it."

No mention is made of SUBHEADs disappearing - this seems to be a bug, I would open a case - there seems to be no logical reason for this behaviour.

The issue seems to be MULTILINES - remove it and the subheadings appear. Seems to be a bug.

SET PRINTPLUS = ON

TABLE FILE CAR
SUM 
SALES
DEALER_COST
BY COUNTRY NOPRINT 
BY CAR
BY MODEL

ON COUNTRY SUBHEAD
"COUNTRY SUBHEAD <COUNTRY"

ON COUNTRY SUBFOOT MULTILINES
"COUNTRY SUBFOOT <COUNTRY"

ON TABLE FOOTING
"FOOTING"

ON TABLE SUBFOOT
"TABFOOTING"

ON TABLE SET PAGE-NUM NOLEAD 
END


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     [CLOSED]Subhead missing when adding SET PRINTPLUS =ON

Copyright © 1996-2020 Information Builders