SQL*PLUS report format issue: Is that possible

[kzhangkzhang]

Hi All:

I am creating a SQL*PLUS (not Oracle report) report. The code segment liks following:

==============================================
set newpage 0
set pagesize 55

BREAK ON component desc quantity

select ..... from ....

===============================================

When I run this report, I got the following result (Let us assume the report generate 2 pages of data)

page 1 looks like:

Component Desc quantity subinv
--------- ---- -------- ------
12345 test 10 abc
WIP-C

34567 test2 20 mysub
mysub2

Page 2 looks like (notice that the information about component 34567 will continually show in page 2) :
Component Desc quantity subinv
--------- ---- -------- ------
34567 test2 20 mysub3
mysub4


Here is my request, is there a way for page 2 hiding actual data for quantity column for component 34567? The desired output for page 2 would look like the following:

Component Desc quantity subinv
--------- ---- -------- ------
34567 test2 mysub3
mysub4

The official request for me is: hide the quantity column for the same component when the information for that component continually from page X to page X + 1.

Thanks!

 

[HimanB]

Hi,
Please refer to thread posted by you in Oracle 9i forum.

Regards
Himanshu