slow in next page

[85ascMcLaren]

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]

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.