Automating Report Printing

[Penny]

I have a table containing grades for my dealerships. Each quarter, I go
through each record and run a report that displays the grades in a readable
format.

I'd like to automate this process so that I click one button and have the
all reports automatically print to PDF format instead of me doing each one
individually.

Is this possible?

 

[Mark Andrews]

Penny,

Checkout the email module at http://www.rptsoftware.com it has functions for
batch reporting.

Keeps history of pdf files created and records timestamp and error (if one
happened to occur) for each report to pdf conversion.
Let's you specify the criteria that drive the reports in various ways.

Example Code to create 1,000 pdf files:
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryAppendDailyFixedReportsToQueue"
DoCmd.SetWarnings True

Result = RPT_CreateFiles()


Also if you want to send HTML emails with these pdf attachments you could do
that as well.

Otherwise if you want to write it yourself you need to loop thru a recordset
and then apply criteria (either through a where clause or by dynamically
recreating the queries that drive each report, output it to pdf (using
appropriate method) and use logic to drive the filenames and deal with
overwriting of files etc...

HTH,
Mark