Re: Report Builder 3.0 and Line Feeds

From: Valeri Sorokine <vsorokin_at_dd.ru>
Date: Tue, 06 Jul 1999 17:19:37 +0400
Message-ID: <37820269.175BE44C_at_dd.ru>


Using CHR(10) instead of "linefeed" will help

      return :add2||CHR(10)||:add3;

Fred Kuhne wrote:
>
> 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) ****

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru
Received on Tue Jul 06 1999 - 15:19:37 CEST

Original text of this message