Associating a query with Crystal Reports and setting params at runtime

Nov 20 2004 5:07 PM
Hi, I 've searched this site and some others and can't find a solution. The problem is rather basic. I have a query like this: SELECT * from orders WHERE OrderDate BETWEEN @startdate AND @enddate. the user sets these 2 variables at runtime by using datetime pickers. I can display the results on a datagrid. The problem is how to print the results using Crystal Reports. I know how to display a table using a crystal report at design time, but how associating the report with a query and setting the parameters at run time? any pointers would be appreciated.