Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle 6I - Conditional Printing (eg. address lines)

Status
Not open for further replies.

c15bm

Programmer
May 29, 2003
10
CA
Not super familiar with Oracle Reports (been about 5-6 years). I've modified a report (an invoice) that prints the address. The report would have a company name line, an attention line (if present) then 2 street lines (if necessary) then a city/state line.

When the Attention line is not present, the Street1 line
should print in its place. Likewise, if the Street2 line is not present, the City/State line should print in its place.

Example: (there is an attention line but no street 2 line)
should print like this:

Bob's Gas Company
Atten: John Doe
3345 Seasame St.
Las Vegas,NV 78222

but instead print's like:
Bob's Gas Company
Atten: John Doe
3345 Seasame St.

Las Vegas,NV 78222

I have the original version of the report and as far as I can tell everything is the same - the frames and the property palettes seem to be identical.

Any help appreciated.

Bob Morrison
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top