Combining multiple reports into one report or PDF

Jul B.

unread,

Oct 12, 2009, 3:08:02 PM10/12/09

to

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.

Steve

unread,

Oct 12, 2009, 8:00:05 PM10/12/09

to

Create a new unbound report. Add each of your current reports as a
subreport.

Steve
san...@penn.com

"Jul B." <Ju...@discussions.microsoft.com> wrote in message
news:7C923CF2-BE82-4AA1...@microsoft.com...

StopThisAdvertising

unread,

Oct 13, 2009, 3:04:11 AM10/13/09

to

"Steve" <notmy...@address.com> schreef in bericht
news:X5-dnTRY2aebXk7X...@earthlink.com...

> Create a new unbound report. Add each of your current reports as a subreport.
>
> Steve
> san...@penn.com
>

$teve can't you read ??

Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 10.000 pageloads... it's
a shame !!)

For those who don't 'agree' with this mail , because $teve was 'helpfull' with his post...
We warned him a thousand times... Sad, but he is not willing to stop advertising...

He is just toying with these groups... advertising like hell... on and on... for years...
oh yes... and sometimes he answers questions... indeed...
and sometimes good souls here give him credit for that...

==> We are totally 'finished' with $teve now...
==> Killfile 'StopThisAdvertising' and you won't see these mails....

Arno R

Mark Andrews

unread,

Oct 13, 2009, 10:34:19 AM10/13/09

to

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

"Jul B." <Ju...@discussions.microsoft.com> wrote in message
news:7C923CF2-BE82-4AA1...@microsoft.com...

Mark Andrews

unread,

Oct 13, 2009, 10:34:55 AM10/13/09

to

also stephen lebans web site mgiht have a pdf merge (can't remember).

"Jul B." <Ju...@discussions.microsoft.com> wrote in message
news:7C923CF2-BE82-4AA1...@microsoft.com...

Tony Toews [MVP]

unread,

Oct 13, 2009, 3:44:42 PM10/13/09

to

"Mark Andrews" <mandrew...@rptsoftware.com> wrote:

>also stephen lebans web site mgiht have a pdf merge (can't remember).

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/