Two ideas:
1) Display a report preview to let the user to review the results, the user can then click the print button on the print preview toolbar to print it.

2) Another way would be to run the query once and put the result into one cursor. Use this cursor as the source for your form and then for the report when you print.

Do you need more specifics?

> I am currently designing reports for a project where by one of the reports is based off of the query results from a table that will hold around five hundred thousand to one million records. The issue is that running the query takes around five or ten minutes and to require the user to enter the criteria, run the query to review the results, then run the query again to generate the results for the report seems like a waste of resources. What is the proper way of designing the report? Should I just run the query twice, or should I make the form and report share the same data session? If sharing the data session, what is the best means of doing this? I have tried setting the form's datasession to Default (public) from Private and this did not work. Thanks for any suggestions.
>
>
>Justin Spies