Focal Point
[CASE-OPENED] TABFOOTING border on panelled PDF

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

February 20, 2012, 02:59 PM
nd
[CASE-OPENED] TABFOOTING border on panelled PDF
I have a PDF that automatically panels. The first page of the PDF shows the formatting I would expect.

The second (panelled) page lacks the styling specified for the TABFOOTING. This is especially bothersome with some items we're trying to put inside of borders.

Sample code:
 TABLE FILE GGSALES
SUM 
     GGSALES.SALES01.UNITS/P12C
     GGSALES.SALES01.BUDUNITS/P12C
     GGSALES.SALES01.BUDDOLLARS/P12.2M
     GGSALES.SALES01.DOLLARS/P12.2M
     COMPUTE DIFDOLLAR/P12.2BM = GGSALES.SALES01.BUDDOLLARS - GGSALES.SALES01.DOLLARS;
     COMPUTE DIFUNIT/P12.2SBM = GGSALES.SALES01.BUDUNITS - GGSALES.SALES01.UNITS;
     COMPUTE DOLPERUNIT/D12.2M = GGSALES.SALES01.DOLLARS / GGSALES.SALES01.UNITS;
     COMPUTE BUDDOLPERUNIT/D12.2M = GGSALES.SALES01.BUDDOLLARS / GGSALES.SALES01.BUDUNITS;
BY  GGSALES.SALES01.MONTHYEAR
ON TABLE SUBFOOT
"This is some really long text that should be contained inside of the border, <+0>even if it stretches across two pages. but it does not. that border stops on the first page"
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE ROW-TOTAL AS 'TOTAL'
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     PAGESIZE='Letter',
     LEFTMARGIN=0.500000,
     RIGHTMARGIN=0.500000,
$
TYPE=REPORT,
     FONT='ARIAL NARROW',
     SIZE=10,
     COLOR='BLACK',
     STYLE=NORMAL,
$
TYPE=TABFOOTING,
     BORDER-TOP=HEAVY,
     BORDER-BOTTOM=HEAVY,
     BORDER-LEFT=HEAVY,
     BORDER-RIGHT=HEAVY,
     JUSTIFY=RIGHT,
     HEADALIGN=INTERNAL,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     JUSTIFY=LEFT,
$

TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
	 ITEM=2,
     JUSTIFY=LEFT,
	 POSITION=DIFDOLLAR,
$

TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
	 ITEM=2,
     JUSTIFY=LEFT,
	 POSITION=DIFDOLLAR,
$
ENDSTYLE
END
 

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


WF: WebFocus 7.7.03
Data: Oracle, MSSQL, DB2
OS: Windows
Output: HTML/AHTML,PDF,EXL2K FORMULA, COMT
February 24, 2012, 12:11 PM
Kerry
FYI, nd has a case opened regarding this issue.

nd, please keep us posted on your final solution, thank you.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
March 14, 2012, 03:50 PM
nd
IBI tech support advised me the HEADPANEL=ON option in styling will repeat the borders per page, and for additional control, to use ALIGN-BORDERS.

It's not quite what we wanted--in some cases you want the box to be open on the left/right where the information continues or was continued.

It occurs to me now that in coming back to clean up my post, we could draw the borders on a per cell basis:
Draw top and bottom borders across the lot, left and right borders on only two cells.

I think I overthought it from the get-go.


WF: WebFocus 7.7.03
Data: Oracle, MSSQL, DB2
OS: Windows
Output: HTML/AHTML,PDF,EXL2K FORMULA, COMT