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,

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,

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