Hi,

I have created one ssts Report with the Stored Procedure

Database Data like this:

INSURED NAME STAFF ADJUSTER PRE BR CLMNBR DATE OF LOSS OUTSIDE EFFECTIVE DATE CAUSE OF LOSS O/S LOSS O/S ULAE O/S ALAE PAID LOSS PAID ULAE PAID ALAE SUIT CAUSE OF LOSS STATUS
C & L Wu, LLC and per BE17a attached Arrigo, Laura M 1750 1399311 11/01/2012 NULL Bodily Injury 0.00 0.00 0.00 0.00 0.00 0.00 N Open
C & L Wu, LLC and per BE17a attached Arrigo, Laura M 1750 1399311 11/01/2012 NULL Bodily Injury 0.00 0.00 0.00 0.00 0.00 0.00 N Open
C & L Wu, LLC and per BE17a attached Arrigo, Laura M 1750 1399311 11/01/2012 NULL Medical Payments 0.00 0.00 0.00 0.00 0.00 0.00 N Open
C & L Wu, LLC and per BE17a attached Arrigo, Laura M 1750 1399311 11/01/2012 NULL Medical Payments 0.00 0.00 0.00 0.00 0.00 0.00 N Open

but in Report if i am using Row Grouping associated with "Staff Adjuster".we are not getting the all the duplicate data.we want duplicate data.what we have data into database.

please response immediately

Regards

Narendra





Try this:

create table duplicate_ds
(
c1 int,
c2 int,
c3 int,
c4 int
)

insert duplicate_ds values(1,2,3,4)
insert duplicate_ds values(1,3,4,7)
insert duplicate_ds values(1,3,4,7)
insert duplicate_ds values(3,1,4,4)

SELECT 
ROW_NUMBER() OVER (PARTITION BY c1, c2, c3, c4 ORDER BY (SELECT 0)) AS DuplicateRowNumber,
c1, c2, c3, c4
FROM duplicate_ds

Substitute c1,c2,c3,c4 with your variables and datatypes.

T-SQL Solution

http://dimantdatabasesolutions.blogspot.co.il/2007/02/dealing-with-duplicates.html

but in Report if i am using Row Grouping associated with "Staff Adjuster".we are not getting the all the duplicate data.we want duplicate data.what we have data into database.

When you create the Row Groups you need to ensure that you keep the (Details) level ungrouped.  That way you should be getting all the records that your dataset query returns.  So assuming you only have one group, the Row Groups would look like this:

StaffAdjuster

....(Details)

To get to that result, create a simple table with your detail-level fields. Then right-click the (Details) item in Row Groups and select Add Group > Parent Group...

as mentioned by Valentino...

You must make sure that you are making grouping at correct level otherwise you will be lost in dark.

So start from scratch and think about your groping options.