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. ThanksThis message has been edited. Last edited by: Kerry,
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
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