I have a procedure that worked when using the "=", but I changed to "IN". However, I get a runtime errr orf 3075, Syntax error (missing operator) inquery expression ' DealID IN(29,16) Order by UpdateDate Asc'. The statement looks fine in the debug window
DealID IN(29, 16) Order by UpdatedDate ASC
It looks fine so am not sure why it does not work when passing the filter in the open report statement.