• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4149
  • Last Modified:

Suppressing duplicate data in SSRS

I would like to suppress duplicate data from columns on a report. i cannot find a simple way to do this. in crystal I could select that option, is there an expression for that in SSRS?
The duplicates are showing in the second one down (1009216) for the Location, Type, Persons involved, and App@Scene. I would only like to show them in the first row for that Inc Number 1009216. is this possible?
Duplicate Sample
0
srodgers45
Asked:
srodgers45
  • 3
  • 2
1 Solution
 
Chris LuttrellSenior Database ArchitectCommented:
What version of SSRS are you on?  This is from 2008, you can set the HideDuplicates propery on cells and rows on the Property sheet.
I believe it was similar in 2005 but I do not have older instances to look at anymore to check.
HTH,
Chris HideDuplicates Property
0
 
srodgers45Author Commented:
When I try to hide duplicates on just one field I get the error below. If I do it for the entire dataset it gives another error: "The stream cannot be found.The stream identifier that is provided to an operation cannot be located in the report server database"  I am using 2008
error
This is what the report design looks like
report design
0
 
sureshbabukrishCommented:
in 2005, use Previous function in expression

=IIF(Previous(IncLocation!Field.Value) = IncLocation!Field.Value,true,false) use this in visiblity property expression in the text box in detail section of IncLocation column
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
srodgers45Author Commented:
That works, unfortunately it suppresses the last column of the report I need to show the vaule for. I only want to supress duplicates for each unique record. Any thoughts?

Thank You

The bottom right should also have "True" next to E145, as it is a unique record, like it does next to "BC4" above
 Example
0
 
sureshbabukrishCommented:
use the column name in the expression which differenciates the two rows, i.e BC4,E143,E145,M145 WITH E145 IN THE SECOND ROW.

IIF(Previous(IncLocation!Field.Value) = IncLocation!Field.Value And Previous(IncNum!Field.Value) = IncNum!Field.Value, true,false)

i hope you understood what i meant.
0
 
srodgers45Author Commented:
That worked, Thank You
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now