Problem with displaying and printing main report w/ 7 subreports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main report which contains 7 subreports. One of the subreports also
contains a subreport. When I attempt to run the report - it is very slow. The
first page appears, then when you click the next record, it takes as long to
display the next page. Any suggestions on speeding up the display of the
report.
The database has about 26,000 records.

Also, when I attempt to print the report, the report prints the first page,
then prints the first page again and then the second page, and so on, for
each page it prints, it repeats the printing of the previous pages. This
process is also extremely slow and I would like to know how to speed up the
process.

Many thanks.
 
I have a main report which contains
7 subreports. One of the subreports also
contains a subreport. When I attempt to
run the report - it is very slow. The
first page appears, then when you click
the next record, it takes as long to
display the next page. Any suggestions on
speeding up the display of the report.
The database has about 26,000 records.
Click to expand...

"Click the next record"? That implies that you are previewing, not printing.
Does it also mean that each of the 26,000 records occupies a full page?
That's a lot of memory used in previewing.

If there is data for each subreport, or if you did not specify "can shrink"
for each, then by my calculation, you are running 26,000 x 8 + 1 = 208,001
reports. I am not at all surprised when "slow" is the operative word.
Also, when I attempt to print the
report, the report prints the first page,
then prints the first page again and
then the second page, and so on, for
each page it prints, it repeats the
printing of the previous pages.
Click to expand...

I haven't observed a similar happening, but sometimes strange things happen
when you are working with very large amounts of data relative to the memory
available, as is likely with the report you describe. I did a quick scan of
the Microsoft Knowledge Base, but didn't find anything that appeared
pertinent. This is one of those cases where it would have been helpful had
you included the version and service-pack level of Access that you are
using.

Check at the Microsoft site and apply any Service Packs you haven't
installed already. In Windows 2000 and Windows XP, there's an Office Update
that you can access through the Windows Update, that eases bringing Access
up to date -- but don't do it on a dial-up connection. Some of those updates
are _massive_.

Larry Linson
Microsoft Access MVP
 
Back
Top