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.

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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] PDF overflow with SUBFOOTs

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] PDF overflow with SUBFOOTs
 Login/Join
 
Member
posted
For reasons that I don't need to go into here, I am constrained to be using SUBFOOTs. I was having trouble with the calculations involved with this ... and then I discovered Tony A's solution posted July 15, 2012 09:13 AM, which described a technique of joining a totals file to a detail file and then specifying the totals file's fields in the SUBFOOT. (Incidentally, one of the issues posed in the discussion with this technique was that it didn't provide for a variable number of ACROSS columns; but I was able to get around this by incorporating a bunch of -IF statements ... like this:
 	-IF &NBR_OF_ACROSS_COLUMNS_NOT_COUNTING_TOTALS NE 1 GOTO NOT1;
	"<PUB_DESC<HEAD1<HEAD2<T1.E05<T1.E16"
	"<DUMMY_1<DUMMY_2<HEAD3<T1.E07<T1.E18"
	"<DUMMY_1<DUMMY_2<HEAD4<T1.E13<T1.E24"
	-NOT1
	-IF &NBR_OF_ACROSS_COLUMNS_NOT_COUNTING_TOTALS NE 2 GOTO NOT2;
	"<PUB_DESC<HEAD1<HEAD2<T1.E05<T1.E16<T1.E27"
	"<DUMMY_1<DUMMY_2<HEAD3<T1.E07<T1.E18<T1.E29"
	"<DUMMY_1<DUMMY_2<HEAD4<T1.E13<T1.E24<T1.E35"
	-NOT2
	-IF &NBR_OF_ACROSS_COLUMNS_NOT_COUNTING_TOTALS NE 3 GOTO NOT3;
	"<PUB_DESC<HEAD1<HEAD2<T1.E05<T1.E16<T1.E27<T1.E38"
	"<DUMMY_1<DUMMY_2<HEAD3<T1.E07<T1.E18<T1.E29<T1.E40"
	"<DUMMY_1<DUMMY_2<HEAD4<T1.E13<T1.E24<T1.E35<T1.E46"
	-NOT3
 
... and so forth.)

At last I thought that I'd reached my solution! But, alas, I ran into this:

Due to customer requirements, my report overflowing to a 2nd PDF panel. And for just this reason, I couldn't use
   TYPE=SUBFOOT, HEADALIGN=BODY,  $.

Instead, I calculated the positions of each column.

The body part of the report overflows just fine.


And the SUBFOOT portion overflows, too, but differently. It bleeds over to beyond the right margin. It’s as if the right margins that WebFOCUS calculates for purposes of determining what to put on the overflow panel are different for the main body than for the SUBFOOT lines.



I've looked around a lot for a solution to this. Any help would be greatly appreciated.

This message has been edited. Last edited by: FP Mod Chuck,


7706 gen 902; Windows 10
 
Posts: 14 | Registered: April 12, 2017Report This Post
Member
posted Hide Post
I found a solution.
I used POSITION=xxx.yyy, $ for every SUBFOOT ITEM; and I simply compensated on the one starting the OVERFLOW column ... I added about .2 to the POSITION.

The code looks like this (ITEM 16 is the one with the inflated value):
  
TYPE=SUBFOOT, ITEM=1, JUSTIFY=LEFT, WRAP=.88, $
TYPE=SUBFOOT, ITEM=2, JUSTIFY=LEFT, POSITION=.825, WRAP=.897,  $
TYPE=SUBFOOT, ITEM=4, POSITION=2.41, $
TYPE=SUBFOOT, ITEM=5, POSITION=3.05, $
TYPE=SUBFOOT, ITEM=6, POSITION=3.71, $
TYPE=SUBFOOT, ITEM=7, POSITION=4.38, $
TYPE=SUBFOOT, ITEM=8, POSITION=5.03, $
TYPE=SUBFOOT, ITEM=9, POSITION=5.69, $
TYPE=SUBFOOT, ITEM=10, POSITION=6.35, $
TYPE=SUBFOOT, ITEM=11, POSITION=7.035, $
TYPE=SUBFOOT, ITEM=12, POSITION=7.68, $
TYPE=SUBFOOT, ITEM=13, POSITION=8.345, $
TYPE=SUBFOOT, ITEM=14, POSITION=9.0, $
TYPE=SUBFOOT, ITEM=15, POSITION=9.66, $
TYPE=SUBFOOT, ITEM=16, POSITION=10.51, $
TYPE=SUBFOOT, ITEM=17, POSITION=11.155, $
TYPE=SUBFOOT, ITEM=18, POSITION=11.81, $
TYPE=SUBFOOT, ITEM=19, POSITION=12.465, $
TYPE=SUBFOOT, ITEM=20, POSITION=13.125, $
TYPE=SUBFOOT, ITEM=21, POSITION=13.785, $
TYPE=SUBFOOT, ITEM=22, POSITION=14.445, $
TYPE=SUBFOOT, ITEM=23, POSITION=15.105, $
TYPE=SUBFOOT, ITEM=24, POSITION=15.765, $
TYPE=SUBFOOT, ITEM=25, POSITION=16.425, $
TYPE=SUBFOOT, ITEM=26, POSITION=17.085, $

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


7706 gen 902; Windows 10
 
Posts: 14 | Registered: April 12, 2017Report This Post
Virtuoso
posted Hide Post
It may help other people if you can post your resolved code.

Also, edit your first post then add [SOLVED] at the beginning of the subject


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report 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     [SOLVED] PDF overflow with SUBFOOTs

Copyright © 1996-2020 Information Builders