Re: Newbie Question (help with Reports)

Hi,

I haven't got Reports designer in front of me but you should be able to

1. Write a trigger to collapse the address frame if its contents is null
2. There should be an option on the propeties of the field/frame to collapse if it is null.

See documentaion for more details.

M

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 - 11:20:41 CEST