Solved

Writing reports to .PDF

Posted on 2013-11-15
6
216 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 52

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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
LVL 52

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 52

Expert Comment

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

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

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.…
For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared 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…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

776 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