I have a report whose data comes from SQL-Server. This report has some parameters. The data should come from a SQL-SELECT statement like:

SELECT CusCod, CusName FROM customer 
WHERE CusCod IN (SELECT CusCod FROM sales WHERE SalesDate = ?param)

I'm using VFP7 and CR9 Is there a way to do this? I would like to avoid to create a stored procedure in SQL Server for this report.

TIA

Luis