Printing report re-runs all queries

[ghh3rd]

I have a report with several subreports which run agains a very large table. If I decide to print the report after examining it, all of the underlying queries must run again. Is there any way around this to avoid this delay, other than exporting as rtf or snp?

Thanks,

Randy

 

[KeithG]

Instead of using the reports record source property to view the records try useing the reports recordset property to retrieve the data from an open recordset. You can use the Load event to open the recordset and set the reports recordset property to the recordset you just opened. I believe this should work.