-2

I have an SSRS report with 2-tablix and would like to compare data and highlight rows that not non-duplicates. Any suggestion is appreciated. Thanks

2-tablix for comparison

user2812678
  • 3
  • 5

1 Answers1

0

In table2, for each of the cells you wish to highlight, use the following expression: =IIF(len(Lookup(Fields!ClientID.Value,Fields!ClientID.Value, Fields!LastName.Value,"DataSet2"))>0,"Nothing","Yellow")

SuperSimmer 44
  • 964
  • 2
  • 7
  • 12