Re: Suppressing Duplicate Values in Oracle Reports
From: Nkd <nkd_at_yahoo.com>
Date: Wed, 20 Jul 2005 08:37:33 +0200
Message-ID: <1v9nhwgwreuuy.10gbat49clkus$.dlg_at_40tude.net>
>> 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. Received on Wed Jul 20 2005 - 08:37:33 CEST
Date: Wed, 20 Jul 2005 08:37:33 +0200
Message-ID: <1v9nhwgwreuuy.10gbat49clkus$.dlg_at_40tude.net>
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. Received on Wed Jul 20 2005 - 08:37:33 CEST