Contents of an Object on a Report

From: Moore <rlmoore_at_purdue.edu>
Date: Thu, 27 Jan 2000 16:14:00 -0500
Message-ID: <Pine.SOL.4.10.10001271557210.1371-100000@herald.cc.purdue.edu>

Ladies and Gents,

I am a rookie attempting to dig into Oracle reports. I am working with 2.5.

I have a small task before me in which I need to learn how to access the value of the contents of a field on a report.

Although I am reading as fast as I can to learn how to complete such a task hopefully I can get some insight or a direction from you.

The problem is that I have legacy data and new data. For the report the data needs to be combined. Therefore, some accounts will have a "legacy" account number and some will not.

What I want to do is read the contents of a field on a report, if the contents of the field is equal to '-' then we need to replace the contents of the field with a value from another field in the same query.

For example:

The query: Select cust_num ||'-'||service_loc "ACCT", legacy_acct_num from legacy, customer, service
etc...

Some of the accounts in legacy will not have a customer number and service location. Therefore, if the query returns a '-' for "ACCT' then we need to place the legacy account number in the field on the report.

I realize that I could probably manuipulate the query, however, I want to learn how to write PL/SQL program units.

TIA PS: Forgive my typos... this UNIX text editor is extremely slow and frustrating. Received on Thu Jan 27 2000 - 15:14:00 CST