Print a multipage report to indiviual files

[pkerr]

Is there a way with an Accees report to take the report and have it print
each page as an individual file be it a pdf, word doc, etc?

 

[Mark Andrews]

Sure just loop thru a recordset and create the rtf, snp or pdf file, run the
report using a where clause or custom sql query, create the file
using the appropriate method.

See our email module for an example of batch reporting. It has a nice
couple of functions to make batch reporting easy.

Mark
RPT Software
http://www.rptsoftware.com

 

[pkerr]

Anything out there that might be easier? Like a print utility that you can
have print to a pdf and then create a file for each page?
Thanks for your suggestion

 

[James A. Fortune]

Anything out there that might be easier? Like a print utility that you can
have print to a pdf and then create a file for each page?
Thanks for your suggestion

For Access 2007 there is a free output utility from Microsoft that
allows you to output to PDF:

2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS:

http://www.microsoft.com/downloads/...11-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

In:

http://groups.google.com/group/microsoft.public.access/msg/a4089a4c7aeff448

I said:

I think I remember seeing a free software tool that can split a PDF
file into individual one page PDF files. Googling... Perhaps it was:

http://www.pdfhacks.com/pdftk/

James A. Fortune
(e-mail address removed)

 

[pkerr]

YES!!!!
http://www.pdfhacks.com/pdftk/ was EXACTLY what I needed!
THANKS!!!

 

[Mark Andrews]

I could see using using pdftk for certain operations, usually merging or for
a quick manual operation but if you need to loop
anyway to figure out the filenames, why not just print each report to a one
page pdf. Then you don't need the third party utility at all?

Also if customer #1 happened to have a 3 page report and customer #2 had a 2
page report etc... it would still work. (doesn't apply to you)

We just include a little function (as part of our bigger emailing product)
that sometimes makes the code needed a little easier:

Result = RPT_CreateSingleFile("rptExample",
"C:\Reports\Report34.pdf","PDF","WHERE CustomerID = 34")

if you don't need to create queries on the fly and only have a simple where
clause it's only one line of code in Access (without our product).
Especially in Access2007 becuase they now have PDF output.

pdftk does look like a nice product, I just wouldn't use it if you are
automating the process you described because you do not need it.

My two cents,
Mark

 

[pkerr]

Mark,
Thanks for your earlier input.
The pdftk was perfect for us as we aren't all that "technical" here and
aren't sure what a loop is.