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

Your syntax usage for NOT IN is correct if your using TSQL.  But for CR, I suggest creating the same record selection formula in CR only. Get it working there to make sure that the logic is correct. Once you have it working in CR, copy the record selection formula into your .NET app.

Good Luck