Simon Cowell (X-factor host) is famous for wearing his trousers up round his waist, and WF seems to be taking a leaf out of his book with some (not all) PDF reports.

You request a FOOTING BOTTOM and it does not print at the bottom of the page but about half to 3/4s down the page.

I've not found help on this on Advanced Search and just wonder whether anyone else has had this problem.

Or is it Simon Cowell's revenge: I had everything it takes to be a star but he wouldn't let me past the audition and now I am reduced to being a WebFOCUS programmer!

Would it be possible to post an example that we could run on our systems?

Hammo1J,

FOOTINGS need Styling too:

ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='LETTER',
LEFTMARGIN=0.200000,
RIGHTMARGIN=0.200000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
TOPGAP=0.000000,
BOTTOMGAP=0.000000,
RIGHTGAP=0.125000,
LEFTGAP=.01,
$
ENDSTYLE


BOTTOMGAP,BOTTOMMARGIN will give you the desired result...

Tom

TABLE FILE CAR
SUM SALES BY COUNTRY
HEADING
"HEADING"
" "
FOOTING BOTTOM
"FOOTING"
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='LETTER',
LEFTMARGIN=0.200000,
RIGHTMARGIN=0.200000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
TOPGAP=0.000000,
BOTTOMGAP=0.000000,
RIGHTGAP=0.125000,
LEFTGAP=.01,
$
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END

seems to work on WF 5.3.2

Maybe you are using just FOOTING and not FOOTING BOTTOM ?

This is an example of code that i get the problem on- its not recreated completely due to having substitute my data with car but it should show that the footer is not quite at the bottom despite the bottom margin being set to 0.

To verify this i set the top margin to 0 and the header comes out at the very top, doing so for the bottom margin doesn't force it to come out right at the very bottom; perhaps it's conflicting with something else in the style sheet code.

When i run it on my data the footer appears even higher up the page- it cuts the data off and forces a new page even if the data could fit. It's like there is something forcing it out at the same place on the page meaning it sometimes overwrite my subtotals as well.

any ideas? the conflicting nature of style sheet code baffles and frustrates me and i can't work out what's wrong.

TABLE FILE CAR
SUM RCOST 
BY MODEL
BY COUNTRY

HEADING
"   <+0> <+0>                                                                         BLAH BLAH BLAH            <+0>Run on: &DATEDMYY  "
"   <+0> <+0>                                                                   TITLE"
"  Year: 2007<+0> Period: 09"
"  Directorate: <+0> 1"
"  Division: <+0>2"
"  Function: <+0>3"
"  Department: <+0>4"
"  Acct Type: <+0>5"
"  Acct Group: <+0>6"
" <+32> Period <+17> Year to Date <+21>Totals"
FOOTING BOTTOM
" Page <TABPAGENO of <TABLASTPAGE "
"FSL Commercial in Confidence"
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
  UNITS=IN, PAGESIZE='A4', LEFTMARGIN=0.194444, RIGHTMARGIN=0.194444, TOPMARGIN=0.10000, BOTTOMMARGIN=0.00000,
  SQUEEZE=ON, ORIENTATION=LANDSCAPE,$
 TYPE=HEADING, BORDER-TOP=LIGHT, BORDER-COLOR=RGB(66 66 66), SIZE=10, COLOR='WHITE', BACKCOLOR=RGB(189 190 194), JUSTIFY=LEFT, HEADALIGN=INTERNAL, $
 TYPE=HEADING, LINE=1, ITEM=1, COLOR='BLUE',JUSTIFY=LEFT, WIDTH=1.097, BORDER-LEFT=LIGHT, BORDER-COLOR=RGB(66 66 66), $
 TYPE=HEADING, LINE=1, ITEM=2, COLOR='BLUE', JUSTIFY=LEFT, WIDTH=.792, $
 TYPE=HEADING, LINE=1, ITEM=3, STYLE=BOLD, WIDTH=7.550, $
 TYPE=HEADING, LINE=1, ITEM=4, COLOR='GREEN',  JUSTIFY=RIGHT, WIDTH=1.889, BORDER-RIGHT=LIGHT, BORDER-COLOR=RGB(66 66 66), $
 TYPE=HEADING, LINE=2, ITEM=1, COLOR='BLUE',  JUSTIFY=LEFT, WIDTH=1.097, BORDER-LEFT=LIGHT, BORDER-COLOR=RGB(66 66 66), $
 TYPE=HEADING, LINE=2, ITEM=2, COLOR='BLUE', JUSTIFY=LEFT, WIDTH=.792, $
 TYPE=HEADING, LINE=2, ITEM=3, STYLE=BOLD, BORDER-RIGHT=LIGHT, WIDTH=7.550, $
 TYPE=HEADING, LINE=2, ITEM=4,  WIDTH=1.889, BORDER-RIGHT=LIGHT, BORDER-COLOR=RGB(66 66 66), $
 TYPE=HEADING, LINE=3, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BORDER-COLOR=RGB(66 66 66), $
 TYPE=HEADING, LINE=4, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BORDER-COLOR=RGB(66 66 66), $
 TYPE=HEADING, LINE=5, BACKCOLOR=WHITE, COLOR=BLACK, BORDER-COLOR=RGB(66 66 66), $

 TYPE=TITLE, BORDER=LIGHT, BORDER-COLOR=RGB(66 66 66), BACKCOLOR=RGB(189 190 194), STYLE=BOLD,JUSTIFY=CENTER,  $
 TYPE=TITLE, COLUMN=FSL_DESC,            BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=DIRECTORATE_DESC,    BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=DIVISION_DESC,       BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=FUNCTION_DESC,       BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=DEPARTMENT_DESC,     BORDER=LIGHT,  $
 TYPE=TITLE, COLUMN=NEW_ATY_DESCRIPTION, BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=NEW_AGR_DESCRIPTION, BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=NEW_ABB_ACCOUNT,     BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=PER_ABB_AMOUNT_BALANCE,     BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=PER_ABB_FORECAST,     BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=PER_ABB_BUDGET,     BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=YTD_ABB_AMOUNT_BALANCE,     BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=YTD_ABB_FORECAST,     BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=YTD_ABB_BUDGET,     BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=ABB_FORECAST,     BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=ABB_PREVIOUS_FORECAST,     BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=ABB_BUDGET,     BORDER=LIGHT, $
 TYPE=TITLE, COLUMN=FILL_1, BACKCOLOR=WHITE, WIDTH=0.014, BORDER=OFF, SQUEEZE=0.014,$
 TYPE=TITLE, COLUMN=FILL_2, BACKCOLOR=WHITE, WIDTH=0.014, BORDER=OFF, SQUEEZE=0.014,$
 TYPE=TITLE, COLUMN=FILL_3, BACKCOLOR=WHITE, WIDTH=0.014, BORDER=OFF, SQUEEZE=0.014,$
 TYPE=REPORT, FONT='ARIAL', SIZE=8, COLOR=RGB(102 102 102), BACKCOLOR='NONE', STYLE=NORMAL, $
 TYPE=REPORT,COLUMN=FSL_DESC,SQUEEZE=0.5,$
 TYPE=REPORT,COLUMN=DIRECTORATE_DESC,SQUEEZE=1.4,$
 TYPE=REPORT,COLUMN=DIVISION_DESC,SQUEEZE=1.4,$
 TYPE=REPORT,COLUMN=FUNCTION_DESC,SQUEEZE=1.4,$
 TYPE=REPORT,COLUMN=DEPARTMENT_DESC,SQUEEZE=1.4,$
 TYPE=REPORT,COLUMN=NEW_ATY_DESCRIPTION,SQUEEZE=2.2,WRAP=OFF,$
 TYPE=REPORT,COLUMN=NEW_AGR_DESCRIPTION,SQUEEZE=2.4,WRAP=OFF,$
 TYPE=REPORT,COLUMN=NEW_ABB_ACCOUNT_DESC,SQUEEZE=2.4,WRAP=OFF,$
 TYPE=REPORT, COLUMN=FILL_1, BACKCOLOR=WHITE, WIDTH=0.014, BORDER=OFF,LEFTGAP=0.05, RIGHTGAP=0.05, $
 TYPE=REPORT, COLUMN=FILL_2, BACKCOLOR=WHITE, WIDTH=0.014, BORDER=OFF,LEFTGAP=0.05, RIGHTGAP=0.05, $
 TYPE=REPORT, COLUMN=FILL_3, BACKCOLOR=WHITE, WIDTH=0.014, BORDER=OFF,LEFTGAP=0.05, RIGHTGAP=0.05, $
 TYPE=SUBTOTAL, COLUMN=FSL_DESC,      BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=DIRECTORATE_DESC,       BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=FILL_1, BACKCOLOR=WHITE, BORDER=OFF, $
 TYPE=SUBTOTAL, COLUMN=FILL_2, BACKCOLOR=WHITE, BORDER=OFF,$
 TYPE=SUBTOTAL, COLUMN=FILL_3, BACKCOLOR=WHITE, BORDER=OFF,$
 TYPE=SUBTOTAL, COLUMN=DIVISION_DESC,         BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=FUNCTION_DESC,       BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=DEPARTMENT_DESC,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=NEW_ATY_DESCRIPTION,   BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=NEW_AGR_DESCRIPTION, BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=NEW_ABB_ACCOUNT,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N8,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N9,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N10,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N11,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N12,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N13,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N14,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N15,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N16,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N17,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N18,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, COLUMN=N19,     BORDER-COLOR=RGB(255 255 255), BORDER=ON,$
 TYPE=SUBTOTAL, BORDER=LIGHT, BORDER-COLOR=RGB(255 255 255), BACKCOLOR=RGB(189 190 194), STYLE=-BOLD, $
 TYPE=FOOTING,  BORDER=LIGHT, BORDER-COLOR=RGB(66 66 66), SIZE=10, COLOR='WHITE', BACKCOLOR=RGB(189 190 194), JUSTIFY=CENTER, $
END
  

Whoa, way too much stylesheet!

One thing that I have noticed over the years is the use of ON filedname SUBTOTAL and ON TABLE COLUMN-TOTAL. Usually, you don't need both and if you run a PDF output and toggle the use of SUBTOTAL with and without COLUMN-TOTAL you will see that an additonal few rows of data get displayed when you take out COLUMN-TOTAL (about three I think).

Using your example I didn't get the "Simon Cowell" effect, however, when I changed the ON TABLE NOTOTAL to ON TABLE COLUMN-TOTAL the footer began to move up the screen.

Add ON COUNTRY SUBTOTAL AS 'Total' and the footer moves up a bit more!

Check your fexes and see if you have that combination.

Also don't forget to use ON TABLE SET PAGE NOLEAD as that will shrink the dead space above your headings.

T

quote:

ON TABLE COLUMN-TOTAL

Thanks for the reply Tony A, the code is utilizing

ON FIELD SUB-TOTAL

but it's integral to the report; i also do not have

ON TABLE SET PAGE NOLEAD

or

ON TABLE COLUMN-TOTAL

or

ON TABLE NOTOTAL

in my code either.

im also thinking perhaps something is wrong with my setup due to the fact you don't get the effect when you run the CAR code i posted.

Unfortunatley i can't think of an example of CAR code that will give me more than one page of data as i suspect you need to see the report span to two pages or more to see the 'Cowell' effect.

page-break on country and see if the footings appear at the bottom of each page. Also try SET PRINTPLUS=ON.

Following works for me, footings at very bottom of every page:

SET PRINTPLUS=ON
TABLE FILE CAR
SUM RCOST 
BY MODEL
BY COUNTRY
ON COUNTRY PAGE-BREAK
HEADING
"  Department: <+0>4"
"  Acct Type: <+0>5"
FOOTING BOTTOM
" Page <TABPAGENO of <TABLASTPAGE "
"FSL Commercial in Confidence"
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
  UNITS=IN, PAGESIZE='A4', LEFTMARGIN=0.194444, RIGHTMARGIN=0.194444, TOPMARGIN=0.10000, BOTTOMMARGIN=0.00000,
  SQUEEZE=ON, ORIENTATION=LANDSCAPE,$
 TYPE=REPORT, FONT='ARIAL', SIZE=8, COLOR=RGB(102 102 102), BACKCOLOR='NONE', STYLE=NORMAL, $
 TYPE=HEADING, BORDER-TOP=LIGHT, BORDER-COLOR=RGB(66 66 66), SIZE=10, COLOR='WHITE', BACKCOLOR=RGB(189 190 194), JUSTIFY=LEFT, HEADALIGN=INTERNAL, $
 TYPE=TITLE, BORDER=LIGHT, BORDER-COLOR=RGB(66 66 66), BACKCOLOR=RGB(189 190 194), STYLE=BOLD,JUSTIFY=CENTER,  $
 TYPE=FOOTING,  BORDER=LIGHT, BORDER-COLOR=RGB(66 66 66), SIZE=10, COLOR='WHITE', BACKCOLOR=RGB(189 190 194), JUSTIFY=CENTER, $
END

The BOTTOMGAP setting on TYPE=REPORT is the key to the solution. However this affects the entire report. therefore you need to set BOTTOMGAP to some value for the other elements of the report (HEADING, TITLE, DATA) in order for those to look right as well. Trying to set BOTTOMGAP directly on the FOOTING moves the text but not the BORDERs.

quote:

TYPE=REPORT, FONT='ARIAL', SIZE=8, COLOR=RGB(102 102 102), BACKCOLOR='NONE', STYLE=NORMAL, $
TYPE=HEADING, BORDER-TOP=LIGHT, BORDER-COLOR=RGB(66 66 66), SIZE=10, COLOR='WHITE', BACKCOLOR=RGB(189 190 194), JUSTIFY=LEFT, HEADALIGN=INTERNAL, $
TYPE=TITLE, BORDER=LIGHT, BORDER-COLOR=RGB(66 66 66), BACKCOLOR=RGB(189 190 194), STYLE=BOLD,JUSTIFY=CENTER, $
TYPE=FOOTING, BORDER=LIGHT, BORDER-COLOR=RGB(66 66 66), SIZE=10, COLOR='WHITE', BACKCOLOR=RGB(189 190 194), JUSTIFY=CENTER, $
END

Hi Mickey,

This works for me if i put it in the FOOTING statement so thanks for this, it was beginning to drive me slightly mad!

cheers

Can someone run this and see where they have the footer come out?

when i run this the footer starts approx 2.1 inches up the page and leaves a gap of 1.5 inches between it and the bottom of the page.

Its funny as i got it working, copied the code into two other drill downs im creating and am getting the exact same problem yet nothing i amend in the code fixes it.

As Tony A rightly pointed out i didn't need to post the whole style code last time so have commented out all but the pertinent parts.

i would post a screenshot but don't have access to my file hosting account.

cheers

 TABLE FILE CAR
SUM RCOST
BY COUNTRY
HEADING
" Ref: R1295 <+0> <+0>                                                                          Commercial in Confidence<+0>Run on: &DATEDMYY "
"   <+0> <+0>                                                                   "
"  Year: 2007<+0> Period: 09"
"  Division: <+0>IS"
"  Department: <+0>IS"
"  Acct: 83505"
FOOTING BOTTOM
" Page <TABPAGENO of <TABLASTPAGE "
"FSL Commercial in Confidence"
ON TABLE COLUMN-TOTAL RCOST
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
  UNITS=IN, PAGESIZE='A4', LEFTMARGIN=0.194444, RIGHTMARGIN=0.194444, TOPMARGIN=0.10000, BOTTOMMARGIN=0.00000,
  SQUEEZE=ON, ORIENTATION=LANDSCAPE,$

TYPE=FOOTING ,  BORDER=LIGHT, BORDER-COLOR=RGB(66 66 66), SIZE=10,BOTTOMGAP=0.1, COLOR='WHITE', BACKCOLOR=RGB(189 190 194), JUSTIFY=CENTER, $

ENDSTYLE
END  

I'm on 762 HF3 and my outcome is the same as yours.

Its a funny one thats for sure, anyone else get the same or a different result?

nubi,

Same set-up as yours but with SET PRINTPLUS=ON (as per Darin) and you get what you want. Always one worth remembering

SET PRINTPLUS = ON
TABLE FILE CAR
SUM RCOST
BY COUNTRY
HEADING
" Ref: R1295 <+0> <+0> Commercial in Confidence<+0>Run on: &DATEDMYY "
"   <+0> <+0> "
"  Year: 2007<+0> Period: 09"
"  Division: <+0>IS"
"  Department: <+0>IS"
"  Acct: 83505"
FOOTING BOTTOM
" Page <TABPAGENO of <TABLASTPAGE "
"FSL Commercial in Confidence"
ON TABLE COLUMN-TOTAL RCOST
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
  UNITS=IN, PAGESIZE='A4', LEFTMARGIN=0.194444, RIGHTMARGIN=0.194444, TOPMARGIN=0.10000, BOTTOMMARGIN=0.00000,
  SQUEEZE=ON, ORIENTATION=LANDSCAPE,$

TYPE=FOOTING ,  BORDER=LIGHT, BORDER-COLOR=RGB(66 66 66), SIZE=10,BOTTOMGAP=0.1,
 COLOR='WHITE', BACKCOLOR=RGB(189 190 194), JUSTIFY=CENTER, $

ENDSTYLE
END

Good luck

T

as Alan Partridge would say....'Aha!'

that's solved it and has now become an integral part of my PDF coding arsenal- it's almost like its undoing something inherent in the WebFOCUS code- but what i couldn't begin to imagine.

life saver!

cheers

nubi