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 At least I did!
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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
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
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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...
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