Solved

Suppressing duplicate data in SSRS

Posted on 2011-03-02
6
2,553 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
  • 3
  • 2
6 Comments
 
LVL 26

Expert Comment

by:Chris Luttrell
Comment Utility
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
Comment Utility
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
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:srodgers45
Comment Utility
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
Comment Utility
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
Comment Utility
That worked, Thank You
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now