Re: Suppressing Duplicate Values in Oracle Reports
From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 20 Jul 2005 07:01:04 -0700
Message-ID: <1121868076.162889_at_yasure>
>>ORA-LEARNER wrote:
>>
>>>Hi there,
>>>It seems to be such a basic requirement in reporting world but don't
>>>know how to do this in Oracle reports 6i.
>>>I need to suppress the duplicate values in the report output:
>>>
>>>Current O/P Desired OUTPUT
>>>___________________________________________________
>>>COL1 VAL1 COL1 VAL1
>>>COL1 VAL2 VAL2
>>>COL1 VAL3 VAL3
>>>
>>>Any idea?
>>
>>SELECT DISTINCT ...
Date: Wed, 20 Jul 2005 07:01:04 -0700
Message-ID: <1121868076.162889_at_yasure>
Nkd wrote:
> On Tue, 19 Jul 2005 13:33:04 -0700, DA Morgan wrote: > >
>>ORA-LEARNER wrote:
>>
>>>Hi there,
>>>It seems to be such a basic requirement in reporting world but don't
>>>know how to do this in Oracle reports 6i.
>>>I need to suppress the duplicate values in the report output:
>>>
>>>Current O/P Desired OUTPUT
>>>___________________________________________________
>>>COL1 VAL1 COL1 VAL1
>>>COL1 VAL2 VAL2
>>>COL1 VAL3 VAL3
>>>
>>>Any idea?
>>
>>SELECT DISTINCT ...
> > > If I understand your question right, then I think Daniel's select distinct > won't help in this case. Put The COL1 in different group (Group Left or > Group Above) to act as a master for detail VAL's.
You are correct ... there are two different interpretations of the question: Maybe more. Grouping would solve one of them.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Wed Jul 20 2005 - 16:01:04 CEST