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.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
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
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!
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
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005
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
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
Posts: 13 | Location: Michigan | Registered: December 09, 2008