I skipped version 10 but you should be able to add a Command Object in the Database Expert window. You should be able to cut & past the SQL into the Command Object and use that as your data selection source. Command Objects will accept parameters as needed, though the parameters need to be created in CR before values can be passed.
Also the SQL need to be pure SQL syntax free of any Visual Studio syntax.
Look in the help file under command objects for more info.
Hope this helps
Regards,
John W.
IP Logged
