Hi,
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