As usual I'm trying to accomplish something that seems like it should be really simple but isn't coming together!

I have a report with a footer (currently FOOTING) which is long and needs to wrap. The footer is dynamic so cannot be split into multiple lines manually. The report outputs in PDF and Excel 2K Formula.

In XLS the footer wraps within the report's width without any problem. In PDF I simply cannot get the footer to wrap. I read in this thread that a FOOTING cannot be wrapped. I would be fine to use SUBFOOT but I also need the footer to be bottom-aligned in the report. Using FOOTING I can use FOOTING BOTTOM and it is correctly aligned. However, ON TABLE SUBFOOT BOTTOM generates a syntax error.

Can anyone please suggest any way to either wrap a dynamic length FOOTING or bottom-align a SUBFOOT (in PDF)? Any help very much appreciated.

Hi Tom,

I did this for Marilyn with SUBHEAD. Changing to HEADING works:

  
-* File Marilyn01.fex
SET PRINTPLUS=ON
DEFINE FILE CAR
NEW_CAR/A50V WITH CAR = '12345678901234567890123456789012345678901234567890';
HEADTEXT/A15 WITH CAR = '123465789012345';
CURR_DATE/MDYY WITH CAR = &MDYY;
END
TABLE FILE CAR
SUM
CNT.MODEL
BY COUNTRY NOPRINT PAGE-BREAK
BY CAR


HEADING
"<NEW_CAR><+0><HEADTEXT><+0><COUNTRY><+0>DATE CURR: <CURR_DATE>"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET BYDISPLAY ON
ON TABLE SET LINES 61
ON TABLE SET NODATA ''
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.500000,
     BOTTOMMARGIN=0.500000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     STYLE=NORMAL,
$
TYPE=DATA,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     STYLE=NORMAL,
$
TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     FONT='ARIAL',
     SIZE=10,
     BACKCOLOR=RGB(255 255 153),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     HEADALIGN=INTERNAL,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     SIZE=10,
     STYLE=BOLD,
     JUSTIFY=LEFT,
$
TYPE=HEADING,
     STYLE=BOLD,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$

TYPE=HEADING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     WRAP=2,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=2,
     JUSTIFY=LEFT,
     POSITION=+.0125,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=3,
     JUSTIFY=RIGHT,
     POSITION=+.125,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=4,
     JUSTIFY=RIGHT,
     POSITION=+.0125,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     STYLE=NORMAL,
     JUSTIFY=LEFT,
     POSITION=+.275,
$
TYPE=heading,
     LINE=1,
     OBJECT=TEXT,
     ITEM=4,
     STYLE=NORMAL,
     JUSTIFY=RIGHT,
     POSITION=+.125,
$
ENDSTYLE
END

See if this works for you in FOOTING.

Thanks for your input Daniel - I will give it a go - but doesn't this approach require that I know the text (or at least its length / required number of lines) in advance? I don't know the content of the footer at design-time.

I was just notified I need to bump this thread to stop it being closed. I'm still working on the problem