Crystal Report, select records by keywords

Try this as your selection formula:

 {Vehicles.Description} = "*"+Trim({?DescParameter})+"*"

Select allOpen in new window

scratch that:  Should be:

{Vehicles.Description} like "*"+Trim({?DescParameter})+"*"

Select allOpen in new window

I receive and error in the formula workshop on the parameter name which states: "This array must be subscripted. For example: Array [i]"

The parameter is a string which may contain multiple values but will never have more than one.

Didn't realize {?descParameter} allowed multiple values.  You won't be able to use the Trim.

Try this:

{Vehicles.Description} like "*"+{?DescParameter}+"*"

Select allOpen in new window

I believe if you are using multiple values you may have to use the full name and not use wildcards.

mlmcc

You can use LIKE with a multi-value parameter, as long as it's multiple single values and does not allow ranges.  But the values you're testing have to include wildcards (* or ?), otherwise LIKE will give you the same results as =.  For example, {table.field} LIKE "ab" will only match "ab", while {table.field} LIKE "ab*" will match any string that starts with "ab".  The simplest way to get wildcards in your parameter values is to have the users enter them (you could put a message about them in the parameter prompt).  Otherwise, you could add them yourself (eg. loop through the parameter values and add "*" to the beginning and end of each value).

 However, you should also be aware that LIKE is case sensitive, so, for example, {table.field} LIKE "ab*" will be false if the field is "Ab".

 If you want to do a case-insensitive comparison, you'll need to check each value in your parameter separately (eg. using StrCmp, which has an option to do a case-insensitive comparison).

 James

Thanks for the posts, I will put them to use as soon as i get answers to my other question. At the moment my reports don't work due to that problem discussed in my other question.

Just want to clarify - the formula above is the 2nd approach that James mentioned in his post.  (Looping through the parameters and adding the "*").  Was trying it for myself and thought I'd share the code....

Thank you for the great posts and of course for the code you shared :)