[AccessD] Reports

The time it takes to move from page to page depends in a large part on 
what you're doing in your report.  Somethings I've learned are 
easier/faster to make TSQL and Queries do instead of the report, counts 
for instance and totals.  For some reason the code that Access uses to 
come up with these figures are extremly sloooow

-- 
-Francisco




Martin Reid wrote On 5/20/2004 11:28 AM:

>What sort of time would I expect when moving from Page 1 to Page 500 in a
>report. i.e cliecking to go to the last page??
>
>Fairly complex report which is pulling data from SQL Server using a Stored
>procedure. Opens in under 2 seconds but still takes forever to move to the
>last page.
>
>Given I need to move very quickly from page 1 to page 500 would it be better
>to create an populate a local table with the date and take the hit before
>the form loads??
>
>
>
>Comments??
>
>
>Martin
>
>  
>