January 25, 2012, 06:05 PM
TabbyQatPage Breaks in subfoot
Hi, I'm attempting to generate a letter using webfocus in a PDF format. I'm putting the top of the letter in a SUBHEADER, with the print section displaying data in the middle and finally the subfooter contains a few paragraphs more of text and a close.
The problem since the middle of the letter varies I cannot predict how much room will be at the bottom of the page. If there is not enough room for the subfooter section to print as a whole, then there is an awkward gap at the end of the first page of the letter and the text starts on the second page.
Is there anyway that I can get the subfoot to print as much of itself as it can on the first page, then print the rest of the second page?
Thanks
January 26, 2012, 01:17 AM
Dan SatchellDo you have NOSPLIT turned on? If so, try removing it.
BY sortfield NOSPLIT
ON sortfield SUBFOOT
"subfoot text"
January 26, 2012, 08:29 AM
njsdenAlso make sure to:
SET PRINTPLUS=ON
to make sure your footings are margins work as expected.
January 26, 2012, 11:15 AM
TabbyQatThank you for your fast responses. I am using the PRINTPLUS feature, and I wasn't using the NOSPLIT Feature. Here is basicly what I've written does:
SQL SELECT data1, data2, data3, data4,
data5, data6, data7, data8, data9,
data10, data11, data12, data13, data14,
data15, data16, data17
FROM table1;
TABLE ON TABLE HOLD AS LETTER
END
-RUN
SET PRINTPLUS = ON
DEFINE FILE LETTER
frmt10/HMDDYY=LETTER.LETTER.data10;
frmt11/MDYY=LETTER.LETTER.data11;
ftmt12/A55V= IF LETTER.LETTER.data12 EQ '' THEN 'P.O. BOX' || (' ' || LETTER.LETTER.data13 ELSE LETTER.LETTER.data12;
END
TABLE FILE LETTER
PRINT
'LETTER.LETTER.data1' AS 'Label1'
'LETTER.LETTER.data2' AS 'Label2'
'LETTER.LETTER.data3' AS 'Label3'
'LETTER.LETTER.data4' AS 'Label4'
'LETTER.LETTER.data5' AS 'Label5'
'LETTER.LETTER.data6' AS 'Label6'
BY 'LETTER.LETTER.data7' AS 'Label7'
BY 'LETTER.LETTER.data8' AS 'Label8'
BY 'LETTER.LETTER.data9' AS 'Label9'
ON Table SUBHEAD
" "
" "
" "
" "
" "
" "
" "
" "
" "
" "
" "
"< LETTER.LETTER.data10"
" "
"< LETTER.LETTER.data14"
"< LETTER.LETTER.data12"
"< LETTER.LETTER.data15"
" "
" "
" "
"text here < LETTER.LETTER.data16"
" "
"TEXT LINE"
"TEXT LINE"
"TEXT LINE"
"TEXT LINE"
" "
" MORE TEXT HERE"
" "
ON TABLE SUBFOOT
" "
"TEXT"
"TEXT"
"TEXT"
"TEXT"
" "
"TEXT"
"TEXT"
"TEXT"
" "
"TEXT"
" "
"TEXT"
" "
" < LETTER.LETTER.data17"
"TEXT"
" "
"TEXT"
"TEXT"
"TEXT"
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.00000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
(formatting stuff here)
ENDSTYLE
END