Solved

Identify Duplicate Values in SSRS

Posted on 2012-04-02
2
2,125 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

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

776 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