Multiple parameters not working !

[Slingky]

Please help.

I use ASP to pass parameters to my reports and they all work OK.

But one thing is not working perfectly :
Multiple params.

I have a ParameterField in my report which will contains all values accepted for the part number.

In ASP, i pass for exemple : '101','102','312' to the parameter field "PossibleProducts"
and in my report i added a record selection formula like
partNum in {?PossibleProducts}

It works, except for that exemple.
if i pass 'F-101','BO-36'

it will return F-101 and 101 parts.
Because the "in" string operator used check the string for occurence and not the complete word.

Is there a way to get only F-101 in my exemple except of both possible.

How? Do i need to use a multiple parameter field except of just a string field?

I'm using Crystal Reports Professional 8.

 

[pelajhia]

What type of database are you accessing? I have been looking at 'IN' and the definition I have states 'true if the operand is equal to one of a list of expressions', so it seems like you should NOT be having the problem as you describe it.

Perhaps crystal is passing this badly - can you take a look at the sql that gets generated and see if it still says 'in'?