How to display distinct Records in SSRS

Question

Post reply

How to display distinct Records in SSRS

b.narasimhakumar

SSC-Addicted

Points: 409
More actions
July 14, 2011 at 1:32 am

#254414

Is one can suggest how to display distinct reocrds in SSRS 2008

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246979 More actions · Answer 1

Change your selection query to eradicate the duplicates at source.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

b.narasimhakumar SSC-Addicted Points: 409 More actions · Answer 2

thanx for your reply but i have to do changes in SSRS only not in Data base.

when we compare all the fields of result set it is unique

from there i am showing few fields in the report . due these looks data populated multiple times to the end user

i have avoid that

example

actual data from query is like this

c1 c2 c3 c4

1 2 3 1

1 2 3 2

but i am showng c1,c2,c3 fields only in report

C1 c2 c3

1 2 3

so it seems multiple times data populating .

Phil Parkin SSC Guru Points: 246979 More actions · Answer 3

b.narasimhakumar (7/14/2011)
thanx for your reply but i have to do changes in SSRS only not in Data base.
when we compare all the fields of result set it is unique
from there i am showing few fields in the report . due these looks data populated multiple times to the end user
i have avoid that
example
actual data from query is like this
c1 c2 c3 c4
1 2 3 1
1 2 3 2
but i am showng c1,c2,c3 fields only in report
C1 c2 c3
1 2 3
1 2 3
so it seems multiple times data populating .

I was not suggesting that you modify your database. All you have to do is modify the query which pulls the data into the report.This is part of your report definition and will not modify your database.

Select distinct c1, c2, c3

should suffice in this case. If you look in the 'Data' tab for your report, you should be able to modify things in there.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 4

You might be able to add a group to your report, and not show any detail. But, Phil is right, the best approach is to alter your dataset query with a DISTINCT.

Cody Konior SSCarpal Tunnel Points: 4827 More actions · Answer 5

Group on the field with the duplicated value? The only issue this raises is that SUMs etc work out different to what you might expect; but that's almost all the case.