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 55

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 Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

LVL 55

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 55

Expert Comment

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

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

This article describes a technique for converting RTF (Rich Text Format) data to HTML and provides C++ source that does it all in just a few lines of code. Although RTF is coming to be considered a "legacy" format, it is still in common use... po…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

770 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