Posting Yak Master
Posted - 05/13/2013 : 09:13:21
| Good morning all.
The following query isn't working for me in Crystal Reports. It's the "WHERE Location IN (30,31,32) part that I'm trying to get to work. I get an error saying that "Too few parameters, expected 3". Is there another way to get this effect? If so can you please show me how it's done? I know this is not a CR forum but I'm just looking for SQL Syntax help. Anyone can help me with this? Please.
OEINVH.`CUSTOMER`, OEINVH.`BILNAME`, OEINVH.`TERRITORY`, OEINVH.`INVFISCYR`, OEINVH.`INVFISCPER`, OEINVH.`INVNETWTX`
OEINVH.`LOCATION` IN (`30`,`31`,`32`)