Query Engine Error

Post Author: robert693

CA Forum: Upgrading and Licensing

Hello,

I migrated from Crystal 8.5 to Crystal 10. When I try to run one report that I migrated, I get the following error message:

Query Engine Error: 21000:&#91;Microsoft&#93;&#91;ODBC SQL Server Driver&#93;Subquery returned more than one value. This is not permitted when the subquery follows =, !=, <, <=, >,>= or when a subquery is used as an expression.

I cannot figure out what this is referring to. I have this in my selection if it is any help.

{Staff.Initials} in &#91;"MHV", "NAL", "PAF", "SAC", "DLL", "KV", "TJW"&#93; and{Schedule.Version} = 0 and{@Date}= DateAdd("d", +1,(currentDate)) and{Schedule.Pat_ID1} >= 10000

I am thinking that the @Date selection is what is causing the trouble.

Any help would be greatly appreciated!

Robert