Re: Newbie Question (help with Reports)

From: Frans H. <fransh_at_hotmail.com>
Date: 8 Apr 2002 01:46:26 -0700
Message-ID: <31abf0e5.0204080046.27126185@posting.google.com>

José Arango <arango_at_caribe.net> wrote in message news:<ub29lp6p4uhjdb_at_corp.supernews.com>...
> Hi,
>
> I'm working on a Report that has a Mail Label. I have 4 fields
> (Company_name, address_line1, address_line2, address_line3). I don't want
> this to happen:
>
> The Company Name
> 12 Madison Street
>
> TheCity, ST 885966
>
>
> There are a couple of addresses in the database that don't have a third
> address line so this looks kind of ugly. Any ideas on how to accomplish
> this? Something like "If there's not a 2nd address line...then move up the
> third one?
>
> I'm just starting to use Reports and I do have some SQL experience and some
> basic PL/SQL but I have no idea on how to solve this. I will appreciate
> your help.
>
> Thanks,
> José

Jose,
If I remember well...
Build a function to do the formatting (you can use chr(10) to go to a new line. Publish the result of the fuction through a formula column,

hth,
Frans Received on Mon Apr 08 2002 - 03:46:26 CDT