Faster print outs

[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.

 

[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