Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Writing reports to .PDF

Posted on 2013-11-15
Medium Priority
Last Modified: 2013-11-15
Can I write consecutive reports to a single .PDF file?   How?
Question by:David_W_R
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3

Author Comment

ID: 39651503
This is for the purpose of archiving multiple files into a single .PDF document.
LVL 56

Expert Comment

by:Joe Winograd, EE MVE 2015&2016
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

Author Comment

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.
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

LVL 56

Accepted Solution

Joe Winograd, EE MVE 2015&2016 earned 2000 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:


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

Author Closing Comment

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

Expert Comment

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

Featured Post

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

This article shows how to make a Windows 7 gadget that accepts files dropped from the Windows Explorer.  It also illustrates how to give your gadget a non-rectangular shape and how to add some nifty visual effects to text displayed in a your gadget.…
This article surveys and compares options for encoding and decoding base64 data.  It includes source code in C++ as well as examples of how to use standard Windows API functions for these tasks. We'll look at the algorithms — how encoding and decodi…
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…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

618 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