[AccessD] Reports

Jim Lawrence (AccessD) accessd at shaw.ca
Fri May 21 05:56:34 CDT 2004


Hi Martin:

Check out:
http://www.databaseadvisors.com/newletters/newsletter112003/0311UnboundRepor
ts.htm
(watch for wrap)

The article desribed a process that handled 500 page reports on a regular
bases.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Martin Reid
Sent: Thursday, May 20, 2004 11:29 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Reports


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

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list