Faster print outs

M

manolakshman

Is there a solution to print Access reports faster, because my reports are
5-6 pages. Is there an option of exporting/saving the report in some other
file format to take faster print outs.
 
J

John Spencer

As far as I know there are no other ways to print a report that would be faster.

IF your report takes too long to print, you might examine where the bottleneck
is.

Is there an underlying query for the report? How long does it take to
generate the data?

Are you using sub-reports? Sub-reports can slow down report generation.

Are you using a slow printer?

Once you have isolated what is causing the slowness, then you can start
looking for alternatives to speed up the process.

For instance, a slow query may be helped by indexing fields used to filter the
data and sort the data. If the query is used only for the report, drop the
sorting in the query and use the reports Sorting and Grouping (under the view
menu). Another possibility is that you are using an aggregate query (totals
query) and filtering records after the data is "totaled" instead of before the
data is "totaled".

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top