duplicate rows in drill down

Hi all,
I have a report that drills down some, and is showing duplicate rows.
How can remove the duplicate rows? Cannot do this on the initial sp because
they are not duplicates.
do I need to have an DISTINCT expression in there?
thanks
gvTry doing "Hide duplicate" from the textbox. Usually this works.
Amarnath
"gv" wrote:
> Hi all,
> I have a report that drills down some, and is showing duplicate rows.
> How can remove the duplicate rows? Cannot do this on the initial sp because
> they are not duplicates.
> do I need to have an DISTINCT expression in there?
> thanks
> gv
>
>|||ok
thanks!!
gv
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:81D8952B-BA27-4301-95B4-02EFFF199D52@.microsoft.com...
> Try doing "Hide duplicate" from the textbox. Usually this works.
> Amarnath
> "gv" wrote:
>> Hi all,
>> I have a report that drills down some, and is showing duplicate rows.
>> How can remove the duplicate rows? Cannot do this on the initial sp
>> because
>> they are not duplicates.
>> do I need to have an DISTINCT expression in there?
>> thanks
>> gv
>>|||not working!!
there is 7 testboxes for each row in the group?
only hides duplicates of the one textbox. Need to not show duplictes of the
whole row?
thanks
gv
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:81D8952B-BA27-4301-95B4-02EFFF199D52@.microsoft.com...
> Try doing "Hide duplicate" from the textbox. Usually this works.
> Amarnath
> "gv" wrote:
>> Hi all,
>> I have a report that drills down some, and is showing duplicate rows.
>> How can remove the duplicate rows? Cannot do this on the initial sp
>> because
>> they are not duplicates.
>> do I need to have an DISTINCT expression in there?
>> thanks
>> gv
>>|||In a drill down it is tricky to have this, anyways, If possible can you bring
it from query using distinct.
Amarnath
"gv" wrote:
> not working!!
> there is 7 testboxes for each row in the group?
> only hides duplicates of the one textbox. Need to not show duplictes of the
> whole row?
> thanks
> gv
>
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:81D8952B-BA27-4301-95B4-02EFFF199D52@.microsoft.com...
> > Try doing "Hide duplicate" from the textbox. Usually this works.
> >
> > Amarnath
> >
> > "gv" wrote:
> >
> >> Hi all,
> >>
> >> I have a report that drills down some, and is showing duplicate rows.
> >> How can remove the duplicate rows? Cannot do this on the initial sp
> >> because
> >> they are not duplicates.
> >>
> >> do I need to have an DISTINCT expression in there?
> >>
> >> thanks
> >> gv
> >>
> >>
> >>
>
>