Re: Oracle Reports 2.x Question

Lee,

Dont know if it works in reports 2.x but in 1.1 you just concatenate the fields together into a wrapped separate each by chr(10) to get the line feed and make sure the field is set to wrap.

ie field1||

   decode(field2,'','',chr(10)||field2)||
   decode(field3,'','',chr(10)||field3)||
   decode(field4,'','',chr(10)||field4)||
   decode(field5,'','',chr(10)||field5)||
   decode(field6,'','',chr(10)||field6)||

Used it many time and worked a treat

Mike

Michael Cox          Input Technolgies Ltd
Email                mike_at_kane.demon.co.uk
Compuserve           100045.1715_at_compuserve.com


******************************************************************************