Filtering report by Parameter 1

[DavidSherring]

I am inviting user to input company codes that they wish to exclude from the report. I am then trying to execute the following lines in report record selection formula editor

{COMPANY_ADDRESSES.COMPANY_ID} not in ({?Excluded Companies})

I keep getting error 'The remaining text does not seem to be part of the formula'.

But this works

{COMPANY_ADDRESSES.COMPANY_ID} in ({?Excluded Companies})
WHY?? and how do I do 'not in'?

 

[bdreed35]

You just have "NOT" in the wrong position:

not({COMPANY_ADDRESSES.COMPANY_ID} in ({?Excluded Companies}))


~Brian