I am using an 'IN' statement to return a cluster of records in a subreport. The formula that I am passing to the subreport is created as a string in the main report. For example it could be "V7331_M25", "V7331_R67". My problem is that it selects everything that is contained in my data, even as substrings of my formula string. So in this example, I only want records for items "V7331_M25" and "V7331_R67", and not "V7331" (of which there are also multiple rows).

Is there a way of restricting the IN statement to return only those rows that have an exact match? It seems that the Crystal function automatically does a 'Like'.

No, that was simply an example of the data that is being included incorrectly in my cluster of records returned.

Thankyou Kurt. I have since discovered that what I am returning is an array, and trying to convert this into individual strings will, I believe, give me a solution, since then I can do in my selection formula ((field="X") OR (Field="Y")) but doing that conversion is proving difficult.

Essentially though I think the CR 'IN' statement does much the same as an SQL 'LIKE' statement. Not good!

New thread started under 'Extracting strings from Array in Subreport'