473,322 Members | 1,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Oracle reports v 6 (&crm ebusiness)--sql query, of using decode

Hiyas

I am currently working on Oracle Report which ties in with my a report
in the ebusiness suite of Oracle telesales module.

Basically, the address on statement reports have blank fields (null)
where the customer does not have and address2, address 3,

At present its set up to read customers
ADDRESS1
CITY
COUNTY
POSTAL CODE

But if the customer does have an address 2 or 3 fields I can do this
by adding in ADDRESS2 AND ADDRESS3 to both my SQL Query and report.
However, not all addresses have 2nd & 3rd Address fields, hence all
the other statments will appear as 'null fields' making the address
for some customers gappy?

I want to write a DECODE statement whereby, if ADDRESS2 AND ADDRESS3
are NULL to skip to the next field being 'CITY'?

Please help...

Cheers
Jul 19 '05 #1
1 4232

"etravels" <em******@yahoo.co.uk> wrote in message
news:d1**************************@posting.google.c om...
| Hiyas
|
| I am currently working on Oracle Report which ties in with my a report
| in the ebusiness suite of Oracle telesales module.
|
| Basically, the address on statement reports have blank fields (null)
| where the customer does not have and address2, address 3,
|
| At present its set up to read customers
| ADDRESS1
| CITY
| COUNTY
| POSTAL CODE
|
| But if the customer does have an address 2 or 3 fields I can do this
| by adding in ADDRESS2 AND ADDRESS3 to both my SQL Query and report.
| However, not all addresses have 2nd & 3rd Address fields, hence all
| the other statments will appear as 'null fields' making the address
| for some customers gappy?
|
|
|
| I want to write a DECODE statement whereby, if ADDRESS2 AND ADDRESS3
| are NULL to skip to the next field being 'CITY'?
|
| Please help...
|
| Cheers

you might want to try just setting Vertical Elasticity property for the
fields

regarding the decode, you can use the standard syntax [ decode ( expression,
match1, display1, match2, display2.... default) ] on the concatenation of
ADDRESS2 and ADDRESS3,
or use a decode for each, appending the expression(s) to the address1
column. don't forget to imbed a newline with the appended address line(s)

;-{ mcs
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: FuzzyBear | last post by:
Hi, How do dependencies work with Oracle reports? I have a set of developers creating reports in Report Builder 6 w/ Oracle 8i and every time the stored packages change that the report uses,...
0
by: Rohit Dhawan | last post by:
I have Oracle 9.2 installed in my computer and want to use Oracle reports builder 6i. Is it possible to use both of them. When I tried to install Oracle report an Forms 6i the Oracel Installer...
1
by: rishka | last post by:
Rishka Mar 17, 5:40 am show options Newsgroups: comp.databases.oracle.tools From: "Rishka" <ris...@webmail.co.za> - Find messages by this author Date: 17 Mar 2005 05:40:45 -0800 Local:...
1
by: novie | last post by:
I have an Oracle report and I am using the Down/Across Print Direction, for only a section of the report. I have A query that is used to select the students and then those ids are passed to a nother...
1
by: Deven Oza | last post by:
Hello everyone Please help me for the following query I want to solve the query Using the (DECODE) function, I want to write a program segment that will successfully decode all the CIS courses...
2
by: jai83 | last post by:
Hi, I have few reports which have been created using the Microsoft Sql Server Reporting Services.Now i want to create similar reports using Oracle Reports 10g. Will i need to start from scratch the...
1
DEVELOPERatHTS
by: DEVELOPERatHTS | last post by:
Hi, I am working on a requirement where I am returning a string to oracle reports which is more than 4000 characters long. As we know reports 6i has a limitation and it does not allow the diplay...
2
by: debashish113 | last post by:
hi all, i have been working on oracle reports using oracle reports builder for few weeks. i am facing a problem to generate a sub report from a main report and the syntax i.e. srw.run_report( ) is...
4
by: tatipellinaresh | last post by:
Hi, I am using Oracle Reports builder for reports. I have one pie graph in my report. It contains 3 fields like lastmonth, lastweek, today. what I want to do is, when I click on a field it should...
1
by: tatipellinaresh | last post by:
Hi, I am working on oracle reports builder. I am using bar graph. I am getting data as Jun-2008 but it is displaying Jun-2 on X-axis. anyone can help me out. Thanks Naresh
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.