Re: Newbie Question (help with Reports)

I suppose there is nothing else on the same line that you want to get rid of...
Well, open the Property Palette, choose "Conditional Formatting", "Hide Object", applied with the "is null" condition, should not work, you'll have to resort to some kind of trickery using formatting triggers which is a bit too complex to explain here.

Hope it helps
Flavio

"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é
>
Received on Mon Apr 08 2002 - 03:43:44 CDT