Focal Point
[SOLVED] SUBHEAD IN PDF REPORT

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9047013016

September 27, 2011, 10:38 AM
wf_devloper
[SOLVED] SUBHEAD IN PDF REPORT
Hi,
Is there a way to repeat the contents in subheading when data is displayed in more than one page like the way the heading gets repeated in the report.
Thanks

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


WF 7.7.05 on Linux
HTML, PDF, EXCEL
September 27, 2011, 10:59 AM
Francis Mariani
TYPE={REPORT|headfoot [BY=sortcolumn]}, HEADPANEL={ON|OFF}, $


Documentation:

Creating Reports With WebFOCUS Language > Using Headings, Footings, Titles, and Labels > Support for Repeated Headings and Footings on Panels in PDF Report Output

Creating Reports With Report Painter > Adding a Page Heading or Footing > Repeat Headings and Footings Per Panel in PDF Report Output


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
September 27, 2011, 11:24 AM
wf_devloper
Hi Francis,
according to your code it works when there are columns that do not fit in a single page but in my case i have 3 columns with overflowing data (200 records for each sort field) and i want to repeat my SORT SUBHEAD when ever the data is more than one page.


WF 7.7.05 on Linux
HTML, PDF, EXCEL
September 27, 2011, 11:35 AM
Francis Mariani
It's not my code. The HEADPANEL stylesheet setting is supposed to take care of "Repeat Headings and Footings Per Panel in PDF Report Output"...

Maybe it works in conjunction with the SET PANEL setting...


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
September 27, 2011, 11:46 AM
wf_devloper
I think HEADPANEL stylesheet setting works when you have columns overflowing to multiple pages but not the data.


WF 7.7.05 on Linux
HTML, PDF, EXCEL
September 27, 2011, 12:47 PM
Francis Mariani
Using this code, please explain what you're expecting to happen:

-* File fpwfdevloper1.fex

TABLE FILE CAR
PRINT
SEG.BODYTYPE
SEG.LENGTH

BY COUNTRY

HEADING
"THIS IS A CAR REPORT"
"PAGE:<TABPAGENO"
" "

ON TABLE PCHOLD FORMAT PDF

ON TABLE SET STYLE *
TYPE=REPORT, HEADPANEL=ON, $

ENDSTYLE
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
September 27, 2011, 01:02 PM
MAdams1
Please see this post;
http://forums.informationbuild...321068081#5321068081

Code taken from that post, I think this is what you are trying to accomplish Thanks to TexasStingray

TABLE FILE GGSALES
HEADING
"Page <TABPAGENO"
SUM
	DOLLARS
	BUDDOLLARS
AND COMPUTE ROWCNT/I9 = LAST ROWCNT + 1; NOPRINT

BY REGION NOPRINT
BY ST
BY CITY
BY STCD
BY PRODUCT
BY TOTAL ROWCNT NOPRINT

ON ROWCNT SUBHEAD
"Region: <REGION "
WHEN REGION NE LAST REGION OR TABPAGENO NE LAST TABPAGENO;

WHERE READLIMIT EQ 1000
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     PAGESIZE='Letter',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.250000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=ON,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=SUBHEAD, BY=6, BACKCOLOR=YELLOW,$
ENDSTYLE
END




WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
September 28, 2011, 09:27 AM
wf_devloper
Hi MAdams1,
Thanks for the reply. I was looking for the same functionality.
thanks once again


WF 7.7.05 on Linux
HTML, PDF, EXCEL