Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Suppress blank line in Oracle Reports

515690Jul 27 2006 — edited Jul 27 2006
I have to produce an organization report with multiple organizations and their addresses. There are 3 address lines but in some case either line 1 or 2 are blank. How can I suppress those lines and close up the print output. For example, if line 2 is blank I only want to print line 1 and 3 with no gap.
Thanx for your help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2006
Added on Jul 27 2006
2 comments
353 views