Report Builder 3.0 and Line Feeds

From: Fred Kuhne <anonymous_at_web.remarq.com>
Date: Fri, 25 Jun 1999 11:31:26 -0800
Message-ID: <930339088.9154_at_www.remarq.com>

I'm trying to format customer addresses on a report. I would like to do all logic checking for blank lines in a formula column, concatenate all address lines with appropriate line feeds and and return the result. Something like this:

if :add1 is null then
  if :add2 is null then

     return :add3;
  else

     return :add2||linefeed||:add3;
  end if;
else
  return :add1||linefeed||:add2||linefeed||:add3; end if;

Any ideas? (This is not for a web report)

Thanks!

• Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****

Received on Fri Jun 25 1999 - 21:31:26 CEST