Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Question (help with Reports)
Hi,
I haven't got Reports designer in front of me but you should be able to
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 - 04:20:41 CDT