How to skip a blank line when doing Oracle reports [message #77774] |
Thu, 15 November 2001 17:56 |
hanna
Messages: 1 Registered: November 2001
|
Junior Member |
|
|
I need to print an address in an Oracle report. There
are two address lines, most of the time the address line 1 has values but not the address 2. Below the address 2 line, I would like to put the city. If the address line 2 is null, how to make the city come directly after the address line 1 without having a blank line. Thanks a lot for your help!
----------------------------------------------------------------------
|
|
|
Re: How to skip a blank line when doing Oracle reports [message #77775 is a reply to message #77774] |
Thu, 15 November 2001 18:25 |
waris
Messages: 115 Registered: November 2001
|
Senior Member |
|
|
hi hanna...
create a formula column and in the formula column
write the code...
if :adress1 is not null then
v_address:=:address1;
elsif :address1 is not null and :address2 is not null then
v_address:=:address1||chr(10)||:address2;
end if;
return v_address;
i hope this answers ur question...thanx for the question..have a great day...
nnnjoyy
waris
----------------------------------------------------------------------
|
|
|