Crystal Reports 2008 - Finding an array value in a string
Posted on 2010-09-10
I've got a report with an optional parameter for Lot # (ex. n498p). The field in the database is a string field that could contain multiple lot numbers (ex. "n498p, n502p"). For the report parameter, I want to use multiple values so they can search for 1 or more lot numbers. In the record selection formula, how do I loop through that array to check each value and see if it show up "in" the string field?