SQL Expression help

[pleashelp]

I am using CR 8.5. Have the following sql statement that returns a row when I run it in Sql Query. But i get Sql errors when I try to put it into a SQL expression in CR.

select sum(iAmount) from voucher WHERE iDeviceID in(select iDeviceID from Devices WHERE strDeviceType ='CT')

wht am i doing wrong?

 

[synapsevampire]

SQL Expressions aren't for executing subqueries.

They're for things like substring(), CASE, etc.

If you want to limit rows to those WHERE strDeviceType ='CT', you can edit the record selection formula to do so, or upgrade to CR 9, where you can use real SQL.

-k