Long running report

S

Smandl

I have a report that is taking about 8 minutes to run. The query that the
report runs off of is running quickly. I dont have anything other then simple
sum calculations in the report so I am a little stumped
 
S

SA

smandl:

Look at the code you may have in the report. If you have any code in the On
Format event, look at changing it to the On Print event. The format event
can fire repeatedly when a report is run, causing your code to run many,
many times, slowing down a report dramatically.
 
S

Smandl

There is nothing in On fomat. I have ran all the queries that compile the
info for this report and they seem to be running normally. Even the query the
report get's it's data from is running fine.
 
Top