Solved

Writing reports to .PDF

Posted on 2013-11-15
6
217 Views
Last Modified: 2013-11-15
Can I write consecutive reports to a single .PDF file?   How?
0
Comment
Question by:David_W_R
  • 3
  • 3
6 Comments
 

Author Comment

by:David_W_R
ID: 39651503
This is for the purpose of archiving multiple files into a single .PDF document.
0
 
LVL 53

Expert Comment

by:Joe Winograd, EE MVE
ID: 39651540
How are you writing the consecutive reports? Is it an application? If so, commercial (which one) or home-brew? Is it via a PDF print driver? If so, which one? Or are you saying that you want to merge existing (already written) PDFs into a single PDF? Need to understand the situation better. Regards, Joe
0
 

Author Comment

by:David_W_R
ID: 39651629
We produce paper quarterly reports for clients, by sending 3 Access reports to the paper printer for each client, rp_1, rp_2, and rp_3.  I would like to send rp_1 to a .PDF after printing the paper copy, then after printing paper copy of rp_2, add that to the .PDF which holds rp_1, then do the same with rp_3.

If possible, then, for the next client, I would like to append this same PDF with the 3 reports for client 2 etc.

I don't know anything about PDF print drivers.
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 53

Accepted Solution

by:
Joe Winograd, EE MVE earned 500 total points
ID: 39651696
I know very little about Access, but if you're able to print to a paper printer, you can print to a PDF printer (aka print driver). Printing to a PDF printer creates a PDF file. So you can print the three reports to a PDF file, and since some of the PDF printers have an "append" option, the three reports can go into a single file...indeed, all three reports for all clients can go into a single PDF file.

There are many free PDF print drivers out there. Six good ones are Bullzip, CutePDF Writer, doPDF, Nitro PDF Creator (part of the Nitro Reader install), PDFCreator, and PrimoPDF:

http://www.bullzip.com/products/pdf/info.php
http://www.cutepdf.com/Products/CutePDF/writer.asp
http://www.dopdf.com
http://www.nitroreader.com/
http://www.pdfforge.org/pdfcreator
http://www.primopdf.com

They have varying features and some folks prefer one over the other, so you may want to experiment to see which one you like the best. Also, in your case, having the "append" option is important, but I don't know off the top of my head which ones have it (Bullzip does). At one time CutePDF was my favorite, then it was doPDF, and my current choice is Bullzip. So I suggest trying Bullzip first to see if it works well for you (and it's a good place to start because it supports "append"). If it doesn't work well for you, try the others until you find one that you like. All of them install a "printer" so that you can "print" to it from any Windows program. When you "print" to it, the print driver will create a PDF file.

Another idea is to create the PDF files directly in Access. Again, I'm not knowledgeable about Access, but I know that other Office apps, including Excel and Word, have a "Save As to PDF" feature. It's likely that Access has it, too (for Reports), but that's just a guess on my part...worth checking out. Regards, Joe
0
 

Author Closing Comment

by:David_W_R
ID: 39651902
You've given me a great lead to follow.   I'll open a new question if further issues arise.
0
 
LVL 53

Expert Comment

by:Joe Winograd, EE MVE
ID: 39651950
OK, good luck on the project! Regards, Joe
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Does Microsoft Office 2016 support COM/ActiveX? 3 113
Query performance - SQL Server 20 84
SignTool Error with Windows 10 5 177
windbg taking it's time 32 93
With most software applications trying to cater to multiple user needs nowadays, the focus is to make them as configurable as possible. For e.g., when creating Silverlight applications which will connect to WCF services, the service end point usuall…
After several hours of googling I could not gather any information on this topic. There are several ways of controlling the USB port connected to any storage device. The best example of that is by changing the registry value of "HKEY_LOCAL_MACHINE\S…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question