I have reports that I am running in a loop with prompts that change each time. Rather than opening and closing the report each time, I am just doing an OpenReport on the existing report with new prompts. This seemed to speed things up, but was unreliable. It didn't always reexecute the query. So I added the ReExecute method. The problem is that now it often executes the query twice, so now the reports take even longer. If I try to use the OpenReportNoExecute method followed by the Reexecute, it doesn't work at all. Has anyone had similar problems with this, or can think of another way to accomplish this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
OpenReport vs OpenReportNoExecute
- Thread starter BethBoyer
- Start date
Similar threads
- Locked
- Question