repeating Group Values

Hi,
I am having a problem with grouping in reporting services. I have data like
below
Col1 Col2 Col3
A B 1
A B 3
K L 1
K L 1
I am creating group on Col1 and Col2.
I nreport I am select 3 columns
Col1 Col2 Sum(Col3)
My results look like below
Col1 Col2 Col3
A B 3
A B 3
K L 2
K L 2
I am not sure why I am getting duplicate data. I want to sum col3 by col1 an
col2. I only want to get one result row per group like in SQL group by result
set.
Please help.
Thanks,
--
SRaniPWhich band are the duplicate rows being displayed in? You will most likely
want to move the display of tCol1, Col2 and SUM(COl3) the 2nd group's footer
band.
"SRaniP" <SRaniP@.discussions.microsoft.com> wrote in message
news:3551D311-578B-4336-B272-347F85FF2100@.microsoft.com...
> Hi,
> I am having a problem with grouping in reporting services. I have data
> like
> below
> Col1 Col2 Col3
> A B 1
> A B 3
> K L 1
> K L 1
> I am creating group on Col1 and Col2.
> I nreport I am select 3 columns
> Col1 Col2 Sum(Col3)
> My results look like below
> Col1 Col2 Col3
> A B 3
> A B 3
> K L 2
> K L 2
> I am not sure why I am getting duplicate data. I want to sum col3 by col1
> an
> col2. I only want to get one result row per group like in SQL group by
> result
> set.
> Please help.
> Thanks,
> --
> SRaniP