Re: slow in next page
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Sun, 30 Mar 2008 00:25:44 +0900
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.
--
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.
"85ascMcLaren" <85ascMcLaren@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D9B1B9F8-3D56-4595-B30A-977CE899DBAA@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: qry vs sql code
- Next by Date: Re: Access 2003 report not using printer default settings
- Previous by thread: Access 2003 report not using printer default settings
- Next by thread: Calculate percentage for each group
- Index(es):
Relevant Pages
|
