Solved

Suppressing duplicate data in SSRS

Posted on 2011-03-02
6
2,967 Views
Last Modified: 2012-05-11
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
Comment
Question by:srodgers45
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 26

Expert Comment

by:Chris Luttrell
ID: 35023103
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
 

Author Comment

by:srodgers45
ID: 35023824
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
 
LVL 9

Expert Comment

by:sureshbabukrish
ID: 35038031
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
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 

Author Comment

by:srodgers45
ID: 35038389
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
 
LVL 9

Accepted Solution

by:
sureshbabukrish earned 500 total points
ID: 35038436
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
 

Author Closing Comment

by:srodgers45
ID: 35038593
That worked, Thank You
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Date Differences SSRS 3 93
Supress rows in SSRS table based on Like or Soundex 2 46
SSRS Get Last Day of Year 2016 2 134
Email based on ssrs data set email 2 30
Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question