[CLOSED]Subhead missing when adding SET PRINTPLUS =ON
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."
================================================= Thanks, SangeethaThis message has been edited. Last edited by: <Emily McAllister>,
Webfocus 8.1.05
July 27, 2016, 02:15 PM
Francis Mariani
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
July 27, 2016, 02:32 PM
Sangeetha Durairaju
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
July 27, 2016, 02:41 PM
Francis Mariani
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