Solved

Writing reports to .PDF

Posted on 2013-11-15
6
213 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 51

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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 51

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 51

Expert Comment

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

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This article shows how to make a Windows 7 gadget that extends its U/I with a flyout panel -- a window that pops out next to the gadget.  The example gadget shows several additional techniques:  How to automatically resize a gadget or flyout panel t…
This article describes how to programmatically preset the "Pages per Sheet" option that's available with most printer drivers.   This setting lets you do "n-Up" printing, where two, four, or more pages are printed on each sheet of paper. If your …
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…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now