I believe you have your param set to allow for multiple values, therefore the {?Region} is an array

One idea, though quite inefficient, would be to run a loop through each of the values and checking whether the record contains one of them. But once you start specifying many many values and you have many many records it really slows down...

But I'd rather think of alternatives ways to accomplishing what you want to do.

At first I was under the impression that you want to allow users to type in whatever characters and get the relevant records, but that doesn't seem to be the case.



You have a list of cities that you want them to select (as opposed to typing in say "h" and getting all the records whose city name contains the word "h").

I have a report that allows users to select multiple names and output a report showing a list of transactions performed by those users.

I used a record selection formula "{my_field} = {?my_param}" and it only displayed the records whose name corresponds to one of the names on the list.

Edited by Keikoku - 21 Dec 2010 at 9:18am

Perhaps instead of using a static parameter you could instead opt for a dynamic one?

Since you are querying the DB for the ones that match your selection, might as well just let the user pick a bunch of options that he wants to see from a dynamically generated list and just return the records whose city field is one of the ones selected.

That way you won't have to worry about concatenation! :)

But I am still looking for a way to write the "contains" logic without using loops.

Edited by Keikoku - 22 Dec 2010 at 3:06am

I think the biggest problem here is the fact that the parameter is an array.

The string function InStr(a, b) returns True if b is a substring of a

Which is what you want! But not for an array

To deal with the array you will have to find ways to either iterate over each element at a time, or see if there's a different function that will handle arrays.

I think it's easiest to just loop over the array for every record, but that may reduce the performance very much.

Edited by Keikoku - 29 Dec 2010 at 3:30am