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.
| 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. |
 |
|
|
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.
|
|
|
|
|
|
|
SSRS Compare rows and highlight matching rows