Associating a query with Crystal Reports and setting params at runtime
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.