Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Footer on Every page of PDF

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Footer on Every page of PDF
 Login/Join
 
Gold member
posted
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
 
Posts: 71 | Registered: June 30, 2009Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 242 | Location: Minneapolis | Registered: February 16, 2006Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Gold member
posted Hide Post
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
 
Posts: 71 | Registered: June 30, 2009Report This Post
Virtuoso
posted Hide Post
sounds like you tried it all.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Virtuoso
posted Hide Post
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,
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Expert
posted Hide Post
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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 189 | Location: Boston, MA | Registered: July 12, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Footer on Every page of PDF

Copyright © 1996-2020 Information Builders