Hello,
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.
i.e.
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!
Thanks
Ivan