I have printplus = on and footing bottom on various reports and the footing has always printed at the very bottom of the report, now that we have upgraded to 7.7.03 the footing is in the middle of the page.

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

This may be worthy enough to open a case with IB.

However, are you using "SET LINES=##" / "ON TABLE SET LINES ##"?

I am using set printplus = on, set lines = 99999, set bottommargin = 0.00000

Donald, which output format are you having trouble with? I'm guessing it's PDF.

This seems to work, perhaps some other code or styling is causing the problem. Try adding the suspect code to this and repost.

-* File fpdonald1.fex

SET PRINTPLUS = ON
SET LINES = 99999
SET BOTTOMMARGIN = 0.00000

TABLE FILE GGSALES
SUM
UNITS
DOLLARS
BUDUNITS
BUDDOLLARS
BY ST
BY CITY
BY DATE

HEADING
"THIS IS THE HEADING"
" "

FOOTING BOTTOM
" "
"THIS IS THE FOOTING"

ON TABLE PCHOLD FORMAT PDF

ON TABLE SET STYLE *
TYPE=REPORT, FONT='Arial', SIZE=10, ORIENTATION=LANDSCAPE, SQUEEZE=ON, $
ENDSTYLE
END

Yes, it is PDF format that is my issue

 SET PRINTPLUS = ON
SET BOTTOMMARGIN = 0.000000
TABLE FILE HOLD2
SUM EXT_PRICE NOPRINT
    TotPrice  NOPRINT
 COMPUTE  TPRICE/D12.2 = TotPrice ; NOPRINT
 COMPUTE TPRICE1/I3 = TPRICE / 1000000 ;  NOPRINT
   COMPUTE TPRICE1A/A3 = EDIT(TPRICE1); NOPRINT
   COMPUTE TP1TXT_A1/A37 = DECODE TPRICE1A (AMOUNT1 ELSE 'ZERO'  );  NOPRINT
   COMPUTE TP1TXT_A2/A37 = DECODE TPRICE1A (AMOUNT2 ELSE 'ZERO'  ); NOPRINT
   COMPUTE TP1TXT_A3/A37 = DECODE TPRICE1A (AMOUNT3 ELSE 'ZERO'  ); NOPRINT
   COMPUTE TP1TXT_A4/A37 = DECODE TPRICE1A (AMOUNT4 ELSE 'ZERO'  ); NOPRINT
   COMPUTE TP1TXT_A0/A37 = IF TP1TXT_A1 NE 'ZERO' THEN TP1TXT_A1 ELSE IF TP1TXT_A2 NE 'ZERO' THEN TP1TXT_A2 ELSE IF TP1TXT_A3 NE 'ZERO' THEN TP1TXT_A3 ELSE TP1TXT_A4 ; NOPRINT
   COMPUTE TP1TXTA/A45V = IF TPRICE1 EQ 0 THEN '(' ELSE IF TPRICE1 EQ 1 THEN '( UN MILLON' ELSE '( ' | TP1TXT_A0 | 'MILLON' ; NOPRINT
   COMPUTE TPRICE2/I3 = ( TPRICE - (TPRICE1 * 1000000) ) / 1000 ; NOPRINT
   COMPUTE TPRICE2A/A3 = EDIT(TPRICE2); NOPRINT
   COMPUTE TP2TXT_A1/A35 = DECODE TPRICE2A ( AMOUNT1 ELSE 'ZERO'  ); NOPRINT
   COMPUTE TP2TXT_A2/A35 = DECODE TPRICE2A ( AMOUNT2 ELSE 'ZERO'  ); NOPRINT
   COMPUTE TP2TXT_A3/A35 = DECODE TPRICE2A ( AMOUNT3 ELSE 'ZERO'  ); NOPRINT
   COMPUTE TP2TXT_A4/A35 = DECODE TPRICE2A ( AMOUNT4 ELSE 'ZERO'  ); NOPRINT
   COMPUTE TP2TXT_A0/A37 = IF TP2TXT_A1 NE 'ZERO' THEN TP2TXT_A1 ELSE IF TP2TXT_A2 NE 'ZERO' THEN TP2TXT_A2 ELSE IF TP2TXT_A3 NE 'ZERO' THEN TP2TXT_A3 ELSE TP2TXT_A4 ; NOPRINT
   COMPUTE LAST_TOKEN/A10 = GETTOK(TP2TXT_A0, 37, -1, ' ', 10, LAST_TOKEN); NOPRINT
   COMPUTE I_IN_NAME/I2 = POSIT(TP2TXT_A0, 37, ' UNO', 4, 'I2'); NOPRINT
   COMPUTE TP2TXT_A00/A37 =IF LAST_TOKEN EQ 'UNO' THEN  SUBSTR(37, TP2TXT_A0, 1 , I_IN_NAME, I_IN_NAME, 'A34') || ' UN' ELSE TP2TXT_A0;NOPRINT
   COMPUTE TP2TXTA/A90V = IF TPRICE2 EQ 0 THEN TP1TXTA ELSE  TP1TXTA || ' '| TP2TXT_A00 || ' MIL' ; NOPRINT
   COMPUTE TPRICE3/I3 = ( TPRICE - (TPRICE1 * 1000000) - (TPRICE2 * 1000) )  ; NOPRINT
   COMPUTE TPRICE3A/A3 = EDIT(TPRICE3); NOPRINT
   COMPUTE TP3TXT_A1/A37 = DECODE TPRICE3A ( AMOUNT1 ELSE 'ZERO'  ); NOPRINT
   COMPUTE TP3TXT_A2/A37 = DECODE TPRICE3A ( AMOUNT2 ELSE 'ZERO'  ); NOPRINT
   COMPUTE TP3TXT_A3/A37 = DECODE TPRICE3A ( AMOUNT3 ELSE 'ZERO'  ); NOPRINT
   COMPUTE TP3TXT_A4/A37 = DECODE TPRICE3A ( AMOUNT4 ELSE 'ZERO'  ); NOPRINT
   COMPUTE TP3TXT_A0/A37 = IF TP3TXT_A1 NE 'ZERO' THEN TP3TXT_A1 ELSE IF TP3TXT_A2 NE 'ZERO' THEN TP3TXT_A2 ELSE IF TP3TXT_A3 NE 'ZERO' THEN TP3TXT_A3 ELSE TP3TXT_A4 ; NOPRINT
   COMPUTE TP3TXTA/A127V = IF TPRICE3 EQ 0 THEN TP2TXTA ELSE TP2TXTA|| ' '| TP3TXT_A0 ; NOPRINT
   COMPUTE TP3TXTA1/A135V = IF CURCODE EQ 'USD$' THEN TP3TXTA || ' DOLARES' ELSE TP3TXTA || ' PESOS' ; NOPRINT
   COMPUTE TPRICE4/D2 = ((( TotPrice - (TPRICE1 * 1000000) - (TPRICE2 * 1000) -TPRICE3 )* 1000 ) +0.5 )/10 ; NOPRINT
   COMPUTE TPRICE5/A2 = FTOA(TPRICE4,'(D2)','A2'); NOPRINT
   COMPUTE TPRICE6/I2 = EDIT(TPRICE5); NOPRINT
   COMPUTE TPRICE7/A2 = EDIT(TPRICE6); NOPRINT
   COMPUTE TPTXTA/A150V = IF CURCODE EQ 'USD$' THEN TP3TXTA1 || ' '| TPRICE7 || '/100 USD )'  ELSE TP3TXTA1 || ' '| TPRICE7 || '/100 M.N. )' ; NOPRINT
BY INV_NO NOPRINT
PRINT
     COMPUTE counter/I3 = IF INV_NO EQ LAST INV_NO THEN counter + 1 ELSE 1; AS ' '
     INV_QTY AS ' ' IN 1
     ORIGINAL_QTY AS ' ' IN 8
     VA_BALANCE_QTY AS ' ' IN 16
    SAE_PART_NAME AS ' ' IN 29
      CUST_PARTNAME AS ' ' IN 37
-*     DESCRIPCION AS ' ' IN 39
    CUST_ORDER_ID AS ' ' IN 61
     CURCODE/A6 AS ' ' IN 73
     SALES_PRICE/P12.4 AS ' ' IN 76
     CURCODE/A6 AS ' ' IN 90
     VALUE_AMOUNT/P12.2 AS ' ' IN 95
COMPUTE PAGELVL/I1 = (counter + 9)/10 ;NOPRINT
COMPUTE FLEETEI/A15 = IF NA_TAX_CODE EQ 'PT' THEN  'I.V.A RETENIDO' ELSE ' '; NOPRINT
COMPUTE FLEETE/D12.2 = IF NA_TAX_CODE EQ 'PT' THEN  EXT_PRICE * NA_TAX_RATE  ELSE 0; NOPRINT
COMPUTE FLEETEA/A14 = IF FLEETE EQ 0 THEN ' ' ELSE FTOA(FLEETE,'(D12.2)','A14');NOPRINT
COMPUTE MONTH_COMPONENT/I2 = HPART(VA_DATE, 'MONTH', 'I2');NOPRINT
COMPUTE MONTHSP/A12 = DECODE MONTH_COMPONENT ( '01' Enero '02' Febrero '03' Marzo '04' Abril '05' Mayo '06' Junio '07' Julio
                                       '08' Agosto '09' Septiembre '10' Octubre '11' Noviembre '12' Diciembre);NOPRINT
COMPUTE DAY_COMPONENT/I2 = HPART(VA_DATE, 'DAY', 'I2');NOPRINT
COMPUTE YEAR_COMPONENT/I4 = HPART(VA_DATE, 'YEAR', 'I4');NOPRINT
BY INV_NO NOPRINT PAGE-BREAK
BY INV_SEQ NOPRINT
BY HIGHEST ALL.ITEM_NAME NOPRINT AS 'ALL,ITEM_NAME'
-*WHERE INV_NO IN FILE SINGLES
-*ON ITEM_NAME  SUBHEAD
-*"        <41 <CUST_PARTNAME  <63 <CUST_ORDER_ID"
ON ITEM_NAME  SUBFOOT
" <40<DESCRIPCION1 "
WHEN DESCRIPCION1 NE ' '
ON ITEM_NAME  SUBFOOT
"  <40<COMMENT_DTEXT1 "
WHEN COMMENT_DTEXT1 NE ' '
HEADING
"      <89 "
" "
"      <86<WH_DNAME <105   <PAGELVL  "
" "
"                            <86<MONTHSP <DAY_COMPONENT <COMMA <YEAR_COMPONENT"
" "
"                                                                                       "
"<2 <SOLD_CUST_NAME                           <60 <SHIP_CUSTOMER "
"<2 <SOLD_ADDR1                               <60 <SHIP_ADDR1 "
"<2 <SOLD_ADDR2                               <60 <SHIP_ADDR2    "
"<2 <SOLD_ADDR3                               <60 <SHIP_ADDR3 "
"<2 <SOLD_CITYSTATE                          <60 <SHIP_CITYSTATE"
"<2 <SOLD_POST                            <60 <SHIP_POST "
"<2 <SOLD_TAXID                           <60 <SHIP_ARCUST_CODE"
" "
" "
"   "
" "
"                                                                                                                  <102 <INV_NO  "
"<2 <NA_SAE_CUST_CODE <13 <CUST_ORDER_HDR_ID   <27 <RegDate <40 <TRANSPORT_NAME <59 <FLETE  <74 <SAL_PAYMENT_EN_NAME <102 <NA_INV_NO "
" "
" "
FOOTING BOTTOM
" "
" "
"<25 <COMMENTS "
"  "
" "
" <25  <NA_INV_DECLARATION1"
"  "
" <25  <NA_INV_DECLARATION2"
" "
" <25  <NA_INV_DECLARATION3"
"  "
" <25  <NA_INV_DECLARATION4"
"  "
" <25  <TPTXTA "
" "
" "
"                   <93 <CURCODE  <95<EXT_PRICE  "
" "
"                    <85 <FLEETEI       <95<FLEETEA  "
" "
"                    <85 <IVAIND      <95<IVA  "
" "
"       <45 <NA_NO_OF_BOXES <56 <NA_WEIGHT  <93 <CURCODE  <95 <TotPrice"
"  "
" <22 <PD_TEXT1C  "
" <18 <PD_TEXT2C"
" <18 <PD_TEXT3C"
" <18 <PD_TEXT4C"
" <18 <PD_TEXT5C                       <74 <NA_OBSERVATION1"
"                                      <74 <NA_OBSERVATION2"
" <22 <PORTD_TEXT1D                    <74 <NA_OBSERVATION3"
" <18 <PORTD_TEXT2C                    <74 <NA_OBSERVATION4 "
" <18 <PORTD_TEXT3C "
" <18 <PORTD_TEXT4C"
" <18 <PORTD_TEXT5C"
" "
" <30 <PORTO_TEXT1C"
" <30 <PORTO_TEXT2C"
" <30 <PORTO_TEXT3C"
" "
" "
WHERE NA_INV_NO EQ '&INVNO.EVAL'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
-*ON TABLE PCHOLD AS INVOICE FORMAT PDF
&PDFOPEN.EVAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='LETTER',
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=6,
     COLOR='BLACK',
     STYLE=NORMAL,
     RIGHTGAP=0.125000,
     BOTTOMGAP=0.000000,
$


TYPE=TITLE,     STYLE=NORMAL,$
TYPE=TITLE,     COLUMN=N2,     SIZE=8,$
TYPE=TITLE,     COLUMN=N4,     SIZE=8,$
TYPE=TITLE,     COLUMN=N6,     SIZE=8,$
TYPE=TITLE,     COLUMN=N8,     SIZE=8,$
TYPE=TITLE,     COLUMN=N12,     SIZE=10,$

TYPE=TABHEADING,     SIZE=8,     STYLE=NORMAL,FONT='COURIER NEW',$
TYPE=TABFOOTING,     STYLE=BOLD,$

TYPE=HEADING,     SIZE=12,     STYLE=NORMAL,$
TYPE=HEADING,     LINE=2,     SIZE=4,$
TYPE=HEADING,     LINE=4,     OBJECT=TEXT,     $
TYPE=HEADING,     LINE=3,     JUSTIFY=RIGHT,$
TYPE=HEADING,     LINE=3,     OBJECT=TEXT,     ITEM=1,     SIZE=9,$
TYPE=HEADING,     LINE=3,     OBJECT=TEXT,     ITEM=2,     SIZE=8,$
TYPE=HEADING,     LINE=3,     OBJECT=TEXT,     ITEM=3,     SIZE=8,$
TYPE=HEADING,     LINE=3,     OBJECT=TEXT,     ITEM=4,     SIZE=8,$
TYPE=HEADING,     LINE=3,     OBJECT=FIELD,     ITEM=1,     SIZE=8,$
TYPE=HEADING,     LINE=3,     OBJECT=FIELD,     ITEM=2,     SIZE=8,WIDTH=0.275, BACKCOLOR=RGB(205 205 205),$
TYPE=HEADING,     LINE=3,     OBJECT=FIELD,     ITEM=3,     SIZE=8,$
TYPE=HEADING,     LINE=3,     OBJECT=FIELD,     ITEM=4,     SIZE=8,$
TYPE=HEADING,     LINE=5,     OBJECT=TEXT,     ITEM=1,     SIZE=9,$
TYPE=HEADING,     LINE=5,     OBJECT=TEXT,     ITEM=2,     SIZE=9,$
TYPE=HEADING,     LINE=5,     OBJECT=FIELD,     ITEM=1,     SIZE=9,$
TYPE=HEADING,     LINE=5,     OBJECT=FIELD,     ITEM=2,     SIZE=9,$
TYPE=HEADING,     LINE=5,     OBJECT=FIELD,     ITEM=4,     SIZE=9,$
TYPE=HEADING,     LINE=6,          SIZE=8,$
TYPE=HEADING,     LINE=7,           SIZE=20,$
TYPE=HEADING,     LINE=8,           SIZE=8,$
TYPE=HEADING,     LINE=9,           SIZE=8,$
TYPE=HEADING,     LINE=10,           SIZE=8,$
TYPE=HEADING,     LINE=11,           SIZE=8,$
TYPE=HEADING,     LINE=12,          SIZE=8,$
TYPE=HEADING,     LINE=13,          SIZE=8,$
TYPE=HEADING,     LINE=14,          SIZE=8,$
TYPE=HEADING,     LINE=15,          SIZE=12,$
TYPE=HEADING,     LINE=16,          SIZE=14,$
TYPE=HEADING,     LINE=17,          SIZE=9,$
TYPE=HEADING,     LINE=18,          SIZE=9,$
TYPE=HEADING,     LINE=19,          SIZE=7,$
TYPE=HEADING,     LINE=20,         SIZE=8,$
TYPE=HEADING,     LINE=20,     OBJECT=FIELD,     ITEM=7,     SIZE=9,$
TYPE=HEADING,     LINE=21,         SIZE=9,$



TYPE=FOOTING,     LINE=1,  STYLE=NORMAL,    SIZE=8,$
TYPE=FOOTING,     LINE=4,  STYLE=NORMAL,    SIZE=8,$
TYPE=FOOTING,     LINE=6,  STYLE=NORMAL,    SIZE=8,$
TYPE=FOOTING,     LINE=8,  STYLE=NORMAL,    SIZE=8,$
TYPE=FOOTING,     LINE=10,  STYLE=NORMAL,    SIZE=8,$
TYPE=FOOTING,     LINE=12,  STYLE=NORMAL,    SIZE=8,$
TYPE=FOOTING,     LINE=14,     SIZE=8,   $
TYPE=FOOTING,     LINE=15,     SIZE=8,   $
TYPE=FOOTING,     LINE=15,OBJECT=FIELD,   ITEM=2,     SIZE=9,WIDTH=1.110795,JUSTIFY=RIGHT,$

TYPE=FOOTING,     LINE=16,     SIZE=4,$
TYPE=FOOTING,     LINE=17,  OBJECT=FIELD,  ITEM=1,WIDTH=1.110795,     SIZE=7, JUSTIFY=RIGHT,$
TYPE=FOOTING,     LINE=17,  OBJECT=FIELD,  ITEM=2,WIDTH=1.110795,     SIZE=9, JUSTIFY=RIGHT,$
TYPE=FOOTING,     LINE=18,     SIZE=4,$
TYPE=FOOTING,     LINE=19,  OBJECT=FIELD,  ITEM=1,SIZE=8,$
TYPE=FOOTING,     LINE=19,  OBJECT=FIELD,  ITEM=2,WIDTH=1.110795,     SIZE=9, JUSTIFY=RIGHT,$
TYPE=FOOTING,     LINE=20,     SIZE=6,WHEN =PAGELVL NE TOTPAG,$
TYPE=FOOTING,     LINE=21,     SIZE=8,   $
TYPE=FOOTING,     LINE=21,    OBJECT=FIELD,   ITEM=4,     SIZE=9,WIDTH=1.110795,JUSTIFY=RIGHT,$
TYPE=FOOTING,     LINE=23, SIZE=7,$
TYPE=FOOTING,     LINE=24, SIZE=7,$
TYPE=FOOTING,     LINE=25, SIZE=7,$
TYPE=FOOTING,     LINE=26, SIZE=7,$
TYPE=FOOTING,LINE=27,SIZE=7,$
TYPE=FOOTING,LINE=28,SIZE=7,$
TYPE=FOOTING, LINE=29, SIZE=7,$
TYPE=FOOTING, LINE=30, SIZE=7,$
TYPE=FOOTING, LINE=31, SIZE=7,$
TYPE=FOOTING,LINE=32,SIZE=7,$
TYPE=FOOTING,LINE=33,SIZE=7,$
TYPE=FOOTING,LINE=35,SIZE=7,$
TYPE=FOOTING,LINE=36,SIZE=7,$
TYPE=FOOTING,LINE=37,SIZE=7,$
TYPE=FOOTING,LINE=39,SIZE=10,$
TYPE=DATA,SIZE=10, $
TYPE=DATA,  COLUMN=N10, FONT='COURIER NEW',     SIZE=11,WHEN= CUST_PART_NAME  EQ ' ',$
TYPE=DATA,  COLUMN=N10, FONT='COURIER NEW',     SIZE=9,WHEN= CUST_PART_NAME NE ' ',$
TYPE=DATA,  COLUMN=N11, FONT='COURIER NEW',     SIZE=11,WHEN= CUST_PART_NAME EQ ' ',$
TYPE=DATA,  COLUMN=N11, FONT='COURIER NEW',     SIZE=9,WHEN= CUST_PART_NAME NE ' ',$
TYPE=SUBHEAD,
     SIZE=9,
     STYLE=NORMAL,FONT='COURIER NEW',
$
TYPE=SUBFOOT,     SIZE=11,FONT='COURIER NEW',$
TYPE=SUBFOOT, LINE=1, OBJECT=TEXT,   SIZE=11,FONT='COURIER NEW',$
TYPE=SUBFOOT, LINE=1, OBJECT=FIELD,   SIZE=11,FONT='COURIER NEW',$

TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
ENDSTYLE
END
-RUN 

Hmmm, I don't know how WebFOCUS would manage to stick 41 lines of FOOTING at the very bottom of the page.

I think it is actually doing it (from the BOTTOM up) until it reaches the middle of your page ... your FOOTING is just too long.

SET PRINTPLUS=ON
TABLE FILE CAR
PRINT CAR AND SEATS
BY COUNTRY
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT PDF
HEADING
"Cars"
FOOTING BOTTOM
"Page: <TABPAGENO"
END

That pushes the FOOTING to the BOTTOM of the page as expected.

This one simulates somehow what you have:

SET PRINTPLUS=ON
TABLE FILE CAR
PRINT CAR AND SEATS
BY COUNTRY
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT PDF
HEADING
"Cars"
FOOTING BOTTOM
" "
" "
"<25 <COUNTRY "
"  "
" "
" <25  <CAR"
"  "
" <25  <CAR"
" "
" <25  <CAR"
"  "
" <25  <CAR"
"  "
" <25  <SEATS "
" "
" "
"                   <93 <COUNTRY  <95<MODEL  "
" "
"                    <85 <COUNTRY       <95<MODEL  "
" "
"                    <85 <COUNTRY      <95<MODEL  "
" "
"       <45 <COUNTRY <56 <CAR  <93 <COUNTRY  <95 <CAR"
"  "
" <22 <COUNTRY  "
" <18 <COUNTRY"
" <18 <COUNTRY"
" <18 <COUNTRY"
" <18 <COUNTRY                       <74 <COUNTRY"
"                                      <74 <COUNTRY"
" <22 <COUNTRY                    <74 <COUNTRY"
" <18 <COUNTRY                    <74 <COUNTRY "
" <18 <COUNTRY "
" <18 <COUNTRY"
" <18 <COUNTRY"
" "
" <30 <COUNTRY"
" <30 <COUNTRY"
" <30 <COUNTRY"
" "
" "
"Page: <TABPAGENO"
END

That also works! I can see "Page: 1" at the very bottom of the page as expected, the other lines are just "pushed up" until they finish somewhere along the middle of the page, but where else would they go?

I can't imagine what that FOOTING looked like in your previous version

I tested your code in v7.7.03, v7.7.02 and v7.6.8. It only works in v7.6.8. I'd open a case.