If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
slow in next page
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 |
#2
|
|||
|
|||
slow in next page
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" wrote in message news 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 |
Thread Tools | |
Display Modes | |
|
|