Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / March 2008

Tip: Looking for answers? Try searching our database.

slow in next page

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
85ascMcLaren - 29 Mar 2008 16:04 GMT
What am I doing wrong in the design of my report.  Without me going into
detail yet, when I execute the report in preview mode, it comes up fairly
quick - let us say 5 seconds.  When I use the next page arrow at the bottom,
it takes 5 minutes to get to the next page.  There are no subreports.  There
is a goup footer that I am performing some summing on, but the transaction
would be the same for the first page or the last page, or the next page.  The
inital first page comes up quick.  The rest - you might as well go to lunch.  
Any suggesstions ?

  Thanks,
     Jason
Allen Browne - 29 Mar 2008 16:25 GMT
There could be lots of reasons for this, depending on what's going on.

Assuming the report is based on a reasonably straightforward query, one of
the worst offenders is where you require Access to keep sections together,
because it may have to go through all the records in a block to discover it
doesn't fit on the page, and then back up to figure out other approaches. It
is possible to really generate a snail by combining this with resizing
sections, hidden sections, and so on.

To see if that is the issue, temporarily set the properties of the sections
(in the Sorting And Grouping box) so it does not have to keep the sections
together.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> What am I doing wrong in the design of my report.  Without me going into
> detail yet, when I execute the report in preview mode, it comes up fairly
[quoted text clipped - 11 lines]
>   Thanks,
>      Jason
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.