I am having a bit of trouble in the Record Selection Formula Editor.

I have passed in delimited string variable from my ASP page into my crystal report.

in the Editor, I cannot get the script to work using a NOT IN statement.


variable passed in: variable1 ("a,b,c,d,e")

statement: field1 NOT IN variable1

it works if I say field1 IN (variable1)

but whay not the other way.

I have tried using the <> operators. But they only work if the variable I am passing in contains a single value i.e. "a"

Please help!