Using split comma delimited string in record selection

[crystaldev1]

Hello, I'm using CR 11 and sql server 2008.

This should be a simple fix which I keep having issues. I have a string parameter such as "Mike,Brown,John,...". I need to split this up and include only the records where {a.name}= "Mike" or "Brown" or "John" or "etc". Number of names can vary from parameter. Thanks.

 

[lbass]

(
ubound(split({?parm},",")) >= 3 and
{a.name}= split({?parm},",")[3]
)

-LB

 

[crystaldev1]

As mentioned, I could have 1 name, 4 names, or none. Will this formula still work?

 

[lbass]

For what? What is your intention? Do you want to include all parameter names in the selection formula? You didn't really indicate that originally.

-LB

 

[lbass]

In retrospect, you should be able to simply use:

{a.name} in {?Parm}

-LB