Compare Value of Field to Any Value in Another Field

[lm1340]

I'm trying to match the value of a field in 'Column A' to any row of data in 'Column B', not just the fields corresponding row.

Column A Column B Match?
1 6 Yes - "1" matches in row2
2 1 No - no match for 2
3 7 No- no match for 3
4 4 Yes- "4" matches in row4

 

[IanWaterman]

What relates the 4 rows?
You will need to group on that and then use variables to capture value of col A and compare with values in ColB

If you can't do that then you will need to use a subreport and pass a shared variable from Col A and look for data in col B in subreport

Ian

 

[lbass]

How will you use this information? Why are you checking for a match? If you just want to be able to detect a match, you can insert a crosstab in the report header or report footer, and then add columnA as the row and columnB as the column. Then create a formula like this:

if columnA = columnB then 1 else 0

Use this as the summary field, and use a maximum as the summary.

-LB