formula for returning multiple lines in P/Footer

[ajdesigns]

Hi
I am using CR 8.5
I am preparing a purchase order report where all items ordered are in the details fields along with any remarks.
ie:
line 1 stapler no 1234-----Ordered item
line 2 bin no 456-----Ordered item
line 3 ** Please mark FAO AJD**----remark
The remarks are specific to previous ordered item so it could be:
line 1 stapler no 1234-----Ordered item
line 2 ** Please mark FAO AJD**----remark
line 3 bin no 456-----Ordered item


all details are kept in 3 warehouses in a sage line 500 D/Base
01 - items
d - remarks
dd - Special Instructions
I have suppressed the dd - Special Instructions from the details but I want them to be shown in the page footer because they are concerning the whole order not just ordered items.
I have a formula: if {warehouse}="dd" then Description.
This only returns the last line of instructions,There could be 2/3 lines.
could I ammend my formula to return all entries in the dd warehouse.

 

[pgtek]

hi
try to expand uour dd field.
right click on your dd field ->format nad check can grow

cheers

pg

pgtek

 

[pgtek]

hi
try to expand your dd field.
right click on your dd field ->format nad check can grow

cheers

pg

pgtek

 

[ajdesigns]

I have tried this by formatting the formula to get the dd field objects into the footet, but it is still only returning the last line

 

[ajdesigns]

I put a sub report in there
Thanks anyway