Problem using "NOT IN" Syntax in crystal report 2008

[vc1881]

Hello,

What is the proper syntax for searching using the NOT IN command?, the IN sybtax works, but the NOT IN is not the proper syntax.


IN Syntax:

myaop29report.RecordSelectionFormula = "{AOP29.field2}in [ " & xyz & "]"

NOT IN Syntax: Error Message (boolean or string expected)

myaop29report.RecordSelectionFormula = "{AOP29.field2} not in [ " & xyz & "]"

Thanks,

Victor

 

[lbass]

not({table.field} in ["A","B","C"])

-LB

 

[vc1881]

It worked

Thank You.