Combining multiple reports into one report or PDF

  • Thread starter Thread starter Jul B.
  • Start date Start date
J

Jul B.

I have several current reports that I'd like to combine into 1 report that
can easily be emailed. Currently, I use the convert multiple reports into
PDF feature in Access 2003 - I'd like to be able to pull all of the reports
into one where I can then send one report via a macro directly to email. The
1st 2 reports have calculated fields for the totals in the report footer
which seems to hose up adding the other reports (which are charts) in as
subreports. Any suggestions? I appreciate any assistance you can give - I
am not very well versed in the reports features of Access. Thanks.
 
What Steve indicated would work. Also you could use one of the third party
tools available to merge pdf files into one file. From what I remember they
can be called with one command line (listing each file and the final output
file). They might cost a few dollars?

Example: do your process to make 3 pdf files
call this third party pdf merge tool to merge everything into one file.
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4GGLL_en&q=pdf+merge

HTH,
Mark
RPT Software
http://www.rptsoftware.com
 
Mark Andrews said:
also stephen lebans web site mgiht have a pdf merge (can't remember).
Click to expand...

Yes it does. There's some sample code in the VBA modules.

A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required. Free.
http://www.lebans.com/reporttopdf.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Back
Top