Solved

Identify Duplicate Values in SSRS

Posted on 2012-04-02
2
2,163 Views
Last Modified: 2012-08-14
How do I identify on an SSRS report duplicate values in a column.  For example I have a list of names and want to highlight in red the names that are the same.  Is there some sort of comparison operation that I need to use?  Please advise.
0
Comment
Question by:Gary Harper
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 250 total points
ID: 37799517
If your data sorted on the column that contains the duplicates, you could use the Previous() function to refer to the previous row:

=Previous(Fields!YourColumn.Value)

See also: http://msdn.microsoft.com/en-us/library/ms156372(v=sql.100).aspx

In case you need to know where to use that function, have a look at the Color property (Font) or the BackgroundColor property of the textbox, depending on what you need.
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 37799945
If the table is not sorted your might be able to change your query in such a way that it has a "IsDuplicate" column, and use that field in your expression.
Another option might be to write your own code to find the duplicates, but I think that's more complicated than changing your query.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

830 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