Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 SSRS Compare rows and highlight matching rows

Author  Topic 

kofseattle
Starting Member

8 Posts

Posted - 2014-03-21 : 14:40:27
I have a report that has two columns that show "origin doc" and "destination doc". In the results I would like to identify by highlighting the rows which have the exact same "origin doc" AND "destination doc" names as another row in the same results. Possible???

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-03-21 : 14:54:06
You probably can do it in the reporting services using Lookup function. The syntax and logic is too much for my brain to hold. Another way (and in my opinion, a simpler way) would be to add column to your query which is something like this:

count(*) over (partition by origindoc,destinationdoc) as DupCount
...
Then, in your report any row for which DupCount is greater than 1 would have duplicates and you can highlight them.
Go to Top of Page

kofseattle
Starting Member

8 Posts

Posted - 2014-03-21 : 15:26:58
This did not work for me but thank you.

quote:
Originally posted by James K

You probably can do it in the reporting services using Lookup function. The syntax and logic is too much for my brain to hold. Another way (and in my opinion, a simpler way) would be to add column to your query which is something like this:

count(*) over (partition by origindoc,destinationdoc) as DupCount
...
Then, in your report any row for which DupCount is greater than 1 would have duplicates and you can highlight them.

Go to Top of Page
   

- Advertisement -