July 14, 2011 at 1:32 am
Is one can suggest how to display distinct reocrds in SSRS 2008
July 14, 2011 at 1:55 am
Change your selection query to eradicate the duplicates at source.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 14, 2011 at 4:04 am
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 .
July 14, 2011 at 4:25 am
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 14, 2011 at 7:17 am
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.
July 14, 2011 at 11:07 pm
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.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply