I'm not sure I get how to do this completely.
I have 5 fields from dataset A that I am comparing to the same fields in dataset B. Dataset A is a sql server 2008 r2 database. the fields in order are: Prolog bdgt allocation(A), JDE Bdgt Allocation(B), Prolog Bdgt Amount(A), JDE Bdgt Amount(B), Prolog Cost Allocation(A), JDE Cost Allocation(B), Prolog Cost Amount(A), JDE Cost Amount(B), Prolog Bdgt Code(A), JDE Bdgt Code(B).
All the 'B' fields are from lookups into the db2 database.
The data looks like this for a row (without the 'A' and 'B' above the fields):
A B A B A B A
Appr Rev Appr Rev ($1,625.00) ($1,625.00) Apprv Commt Apprv Commt ($1,625.00)
B A B
($1,625.00) X128602.1A019200.2450 X128602.1A019200.2450
When each of the 5 fields are an exact match, I do not want to display anything. If any do not match, I want that line to display. This way I can see at a glance if there are any issues to be resolved between the two databases. When I run this report, if there aren't any discrepancies, I want it to display the no rows message. I checked "show or hide based on an expression" in the row and the expression I tried in the row visability property needs to look something like this but I don't know how to refer to the row:
=IIf(Fields!BdgtAllocation.Value <> ReportItems!Target_JDE_BdgtAlloc or Fields!BdgtAppliedAmount.Value <> ReportItems!Target_JDE_BdgtAppliedAmount or Fields!CostAllocation.Value<>ReportItems!Target_JDE_CostAlloc or Fields!CostAppliedAmount.Value<> ReportItems!Target_JDE_CostAppliedAmount or Fields!BdgtCode.Value <> ReportItems!Target_JDE_BdgtCode, (display the row), (hide the row))
I am also not sure if I should refer to the DB2 fields that I populated with a lookup should be referred to by the ReportItems collection.
In your example you had '= Fields!TargetSQLData.Value = Lookup(Fields!KeySQLServerColumn.Value, Fields!KeyIBMColumn.Value, Fields!TargetIBMData.Value, "IBMData")' Does '= Fields!TargetSQLData.Value ' equate to the Row? And if so, how? I was expecting something like 'Tablix!Row' or such. If the first value can reference the row, I think I could follow your example with multiple lookups for each of the 5 fields I need to check, basically having '= Fields!TargetSQLData.Value = Lookup(fields 1) or lookup(fields2) or lookup(fields3) or lookup(fields4) or lookup(fields5)
Your code makes sense, I just can't figure out the name to use for the first field ('= Fields!TargetSQLData.Value' in your example) that I want to be the row or how to tell it to hide or show the row.
Please help as I think I've started bursting blood cells in my brain from too much pondering over this...lol