Print a multipage report to indiviual files

  • Thread starter Thread starter pkerr
  • Start date Start date
P

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?
 
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
 
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
 
pkerr said:
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
Click to expand...

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)
 
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
 
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.
 
Back
Top