Mulitple Value Parameter

[MadCatmk2]

hi

Crystal 8.5
OLEDB connection to SQL server

Could some one enlighten me as to how best to go about doing this. I initially appeneded this question to the end of another post but i feel its now a seperate question.

I have a parameter field in my report that takes a string value from a user. There is a formula in my program which using the like operator checks that the string appears in the relevent database field. The formula looks like this:

if {CIID.Alpha1} like "*" + {?Department} + "*" and {CIID.StyleID} = 5
then
1
else
0

where {?department} is the parameter field.

I would like to be able to search for multiple entries as apposed to just one. I assume i need to first of all set {?department} to accept multiple values. Once i've done that i'm not sure if i need to change anything in the formula, as the data that is being output is not as expected. I have looked at other posts and see that the join command is used in a lot of cases dealing with multiple string value parameters.

What i'd like to know if i need to use the join function and if so how would i go about using it. Either that or if theres any other options.

Thanks in advance

 

[lbass]

I responded to your other post thread767-779847, which I think must be read to understand the idiosyncrasies of this particular problem.

-LB