Newbie Question (help with Reports)

From: José Arango <arango_at_caribe.net>
Date: Mon, 08 Apr 2002 01:18:59 +0228
Message-ID: <ub29lp6p4uhjdb@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é Received on Sun Apr 07 2002 - 17:50:59 CDT