Focal Point
Bottom of PDF Border gets eaten

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

February 23, 2010, 01:13 PM
dreddy_23
Bottom of PDF Border gets eaten
I have several PDF reports that run across several pages and the bottom-line gets eaten on all the pages except the last page.

I have tried
ON TABLE SET PAGE NOLEAD

I have looked around other threads and tried the suggestion posted by some of the other members. None of them worked.

I am giving this in stylesheet
TYPE=REPORT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=10,
COLOR='BLACK',
STYLE=NORMAL,
RIGHTGAP=0.027778,
LEFTGAP=0.027778,
$

Can some one help please?

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


Prod: WebFOCUS 8.1.05 on Win 10
Test: WebFOCUS 8.1.05 on Win 10
February 23, 2010, 02:10 PM
Severus.snape
Hi,

Dont know if you already tried this, but try setting PRINTPLUS to on.

SET PRINTPLUS ON


WF 7.7.03/Windows/HTML,PDF,EXL
POC/local Dev Studio 7.7.03 & 7.6.11
February 23, 2010, 02:12 PM
njsden
Hi dreddy_23,

I don't think there is a solution to that. I have exactly the same behaviour in all of my reports and no matter what I tried in the past I never got the bottom border to show up in intermediate pages.

I think that we just need to learn how to live with this "feature Eeker At least I did! Frowner



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.
February 23, 2010, 02:24 PM
dreddy_23
Thanks Severus.snape!

I have tried both of this but no use.


Prod: WebFOCUS 8.1.05 on Win 10
Test: WebFOCUS 8.1.05 on Win 10
February 23, 2010, 02:25 PM
dreddy_23
Thanks for the reply njsden.


Prod: WebFOCUS 8.1.05 on Win 10
Test: WebFOCUS 8.1.05 on Win 10
February 23, 2010, 03:47 PM
Waz
This can also happen with options like SUBHEAD, SUBFOOT, SKIP-LINE.

It is very difficult to fix, and I usually give up and leave it.

The only way I've been able to fix it is to work out when the botton line should appear, and force it to show, very complicated and convoluted.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

February 23, 2010, 06:02 PM
Doug
I totally agree with Waz... WebFOCUS doesn't seem to keep track of the SUBHEAD, SUBFOOT, SKIP-LINE, etc very well, thus the body of the report spills over (is eaten). the complexity which Waz speaks of involves you (the developer) tracking the actual lines on each given page and doing your own page-break accordingly. It can be done. But, I think (imho) that IB should fix it...




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
February 23, 2010, 06:17 PM
Waz
I also agree that IBI should fix it.

Has anyone put a case in ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

February 23, 2010, 07:04 PM
Doug
I think that we've all put up with it so long, that we've gotten immune to it...

I'll see what I can do about it IF someone comes up with a good example using a standard IBI file...

PM Me, along with your posted code, to ensure that I do not overlook it when it comes thru...
February 23, 2010, 08:04 PM
njsden
quote:
IF someone comes up with a good example using a standard IBI file...


I don't know how complete an example this might be but at least it illustrates the point:

SET PRINTPLUS = ON
TABLE FILE CAR
PRINT 
        CAR          AS 'Brand'
        MODEL        AS 'Model'
        BODYTYPE     AS 'Body Type'
        SEATS        AS 'No. of,Seats'
        DEALER_COST  AS 'Dealer,
        RETAIL_COST  AS 'Retail,Cost'
        SALES        AS 'Total,Sales'
BY COUNTRY NOPRINT
ON COUNTRY PAGE-BREAK AND SUBFOOT 
"TOTAL SALES IN <COUNTRY <ST.SALES"
HEADING
"Cars Inventory"
"Country:  <COUNTRY"
FOOTING BOTTOM
"Page No. <TABPAGENO  OF <TABLASTPAGE"
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, UNITS=PTS, SQUEEZE=ON, FONT='ARIAL', SIZE=9, BORDER=LIGHT, $
TYPE=TITLE, BACKCOLOR=SILVER, STYLE=NORMAL, JUSTIFY=CENTER, $
TYPE=SUBFOOT, BACKCOLOR=SILVER, BORDER=LIGHT, $ <-- BORDER keyword here is redundant!
TYPE=HEADING, LINE=1, SIZE=12, JUSTIFY=CENTER, STYLE=BOLD, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1, STYLE=BOLD, $
TYPE=FOOTING, BORDER=OFF, BORDER-TOP=LIGHT, SIZE=8, JUSTIFY=RIGHT, $
END


This illustrates how both the LEFT and BOTTOM borders "disappear" from the SUBFOOT on each page except for the last one in which at least the BOTTOM border is present but the LEFT one is nowhere to be found. The situation is consistent throughout all of the reports we currently host.

Now, if you look closely at the heading's top border in pages 2 to 5, you will be able to spot a couple of mini-borders on both left and right sides ... it makes me think that this is actually the border chunk missing from the previous page and that somehow got pushed and collapsed onto the next heading. Well, that's just an assumption.

Caveat: This has consistently happened in my Production environment (WebFOCUS 5.3.4) although I am glad to report that, while creating this sample code I found out that it works as expected in my local Dev.Studio 7.6.10 (yay!) Well, bad news is there's no migration to WF 7.6 happening any time soon Frowner

Best,
- Neftali.



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.
February 23, 2010, 08:08 PM
njsden
quote:
it works as expected in my local Dev.Studio 7.6.10


Hey, wait a minute ... I can see that dreddy_23 actually has a 7.6.10 Production environment and he reported the issue as current. Sorry guys, I think my sample code is not that good an example after all Eeker

- Neftali.



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.
February 23, 2010, 09:36 PM
Waz
There is a distinct difference in the way the borders are applied when individual items are used to TYPE=REPORT.

If TYPE=TITLE and TYPE=DATA, are used, then the bottom border is shown, but can be lines away from the data if PRINTPLUS is on.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

February 24, 2010, 09:36 AM
dreddy_23
Thank you all for the replies.

I have tried TYPE=DATA with PRINTPLUS=ON but that makes even worst with a line way to the bottom.

Dreddy.


Prod: WebFOCUS 8.1.05 on Win 10
Test: WebFOCUS 8.1.05 on Win 10
February 24, 2010, 10:58 AM
Steve
We have requested several "border" improvements / fixes with PDF output. This was one of the items that we discussed with IBI. Hopefully they will be able to include it in the 7.6.11 release.


WebFOCUS 7.7.02 Teradata, Oracle
Windows
Outputs: HTML / PDF / Excel
February 24, 2010, 03:43 PM
Waz
Steve, did you put in a case with IBI ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

February 24, 2010, 05:27 PM
Doug
I'm with Steve on this one... This should be fixed in 7.6.11 as per issues given to IB...

Good One Way To Go Steve...

We'll keep that sample (above) for a 7.6.11 test case...
March 02, 2010, 08:48 AM
Dave
Hi, all

I've got the same problem as dreddy_23.

Mine was fixed by just adding a dummy footer.

i.e.
TABLE
SUM A
BY B
ON B SUBFOOT
" "
.....

adding the green worked for me...

it's might help you aswell.

Greets,


_____________________
WF: 8.0.0.9 > going 8.2.0.5
March 05, 2010, 03:05 PM
dreddy_23
quote:
Reply

Dave,

Thanks for your reply. i have tried your suggestion but It is still not working. I will keep trying with other options.

Thanks,
Dreddy


Prod: WebFOCUS 8.1.05 on Win 10
Test: WebFOCUS 8.1.05 on Win 10
March 08, 2010, 10:48 AM
Steve
This issue has not been resolved in 7.6.11.


WebFOCUS 7.7.02 Teradata, Oracle
Windows
Outputs: HTML / PDF / Excel