Focal Point
[CLOSED] Footer on Every page of PDF

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

May 04, 2010, 11:12 AM
Anmol
[CLOSED] Footer on Every page of PDF
Hi,

I am working on a PDF version of a report with page size (Letter or Legal).

Page size (Letter or Legal) with page ORIENTATION LANDSCAPE is unable to contain the large no. of columns on a page; it brings the remaining ones on the next page.

The user agrees with this limitation.

Now the problem

In this scenario user is expecting that Footer information carry over to the next page (one with the exceeded column). Here the Footer was on page 1, but not on page 2.

Can someone suggest how to get the footer on the next page (one with the exceeded column).

Thanks in advance,

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


WebFocus7.6.2, WebFocus 7.1.1,Windows
HTML, PDF and Excel
May 04, 2010, 11:21 AM
Norb Eckert
The overflow of page one is printing on a second page but it's still really only page one's data. So repeat the footer information on the right side of the 1st page and it should print on the overflow page. You'll have to futz with where you want it positioned on the overflow but this should work.

Quite the hack, huh? Personally, I think I'd work on reducing the column widths, gap, or number of columns.


prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9
May 04, 2010, 11:24 AM
Prarie
How many columns are we talking?
Have you tried fixing the report to get it all on one page?
Have you tried reducing the size of fonts and adjusting margins ?
Are column titles bigger than the size of the fields?

There are lots of ways to reduce the size of a report to get it all on one page which is really what you need here.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
May 04, 2010, 11:31 AM
Anmol
quote:
How many columns are we talking?
Have you tried fixing the report to get it all on one page?
Have you tried reducing the size of fonts and adjusting margins ?
Are column titles bigger than the size of the fields?


Please find the answers to your questions inline

How many columns are we talking? --- 25+
Have you tried fixing the report to get it all on one page? -- Yes I Did
Have you tried reducing the size of fonts and adjusting margins ? Yes we are using font size 8 less than this is not user friendly.
Are column titles bigger than the size of the fields? -- Yes they were I have shortened there name as much as I can.

I have tried using WRAP and Specfied Width to the columns and also tried using the LEFTGAP and RIGHTGAP to its minimum possible values.


WebFocus7.6.2, WebFocus 7.1.1,Windows
HTML, PDF and Excel
May 04, 2010, 11:34 AM
Prarie
sounds like you tried it all.
May 04, 2010, 11:40 AM
Darin Lee
As Norb explained, there isn't really a second page. The panelled page (as the page number suggests - 1.2, 1.3) is just an extension of the page. So treat it all like one page, add the footing a few times, and play with the position until you get it right. Margins, font size, etc. will all have an effect on the position. Here's an example:
TABLE FILE CAR
PRINT CAR MODEL MODEL MODEL MODEL MODEL MODEL MODEL MODEL
BY COUNTRY
HEADING
"1234567890"
FOOTING
"<0>THIS IS THE FOOTING<+0>THIS IS THE FOOTING<+0>THIS IS THE FOOTING"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=12,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=FOOTING, ITEM=2, POSITION=N5,$
TYPE=FOOTING, ITEM=3, POSITION=N8,$
ENDSTYLE
END

This message has been edited. Last edited by: Darin Lee,
May 04, 2010, 12:27 PM
njsden
Good One Darin!

This is a good example of a rather interesting expression I heard once ... "if you can't make it, then fake it".

It gets the work done without too much effort and that's what counts!

Anmol, Darin's suggestion will graciously help you with what you need. If you require this report to also work with other output formats (HTML, EXL2K) then Dialog Manager can assist you in having different FOOTING and Style Sheet definitions as part of the same TABLE FILE request, although the GUI may not be too happy about it.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
May 04, 2010, 01:10 PM
GinnyJakes
Just for the sake of staying on top of new stuff, in 7.6.11 you can cause in a stylesheet to have the header and/or footer repeated on the paneled page for PDF. In the stylesheet, syntax is
TYPE=REPORT,HEADPANEL=ON,

This can be selected in the Report Painter on the FORMAT tab, right side, for PDF output.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
May 04, 2010, 01:27 PM
Syed
Unfortunately Anmol (we work in the same team) is currently using 7.1.7, and as it turns out to be, upgrade is not an option at the moment.

I like Darin's suggestion - I had something similar in mind but did not have a working example. This is definitely helpful.

Anmol - lets give this a shot and see if we're able to get it right.

Thanks Darin!

Syed


Using WF 7.1.7/Dev Studio