Converting reports to PDF

[scra]

I have 12 pages of Access reports. Each page is its own report. To convert all reports to PDF, I have to convert each report and then 'bind' them into one using Adobe. Is there a way to convert all 12 pages into one PDF file?

 

[SgtJarrow]

Put all 12 reports into one reports, with each of the 12 being a "subreport", and save this out as PDF as you currently do each one separately???

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[sxschech]

This method still requires binding, but if you know all the reports ahead of time, you could put code in vba to run(print) the reports to pdf so that you don't have to do it one at a time, then, all the reports will be open in acrobat and you can bind them easily by using the Include all open files tick box.

 

[genomon]

If you have the Acrobat SDK you can merge reports - also there are 3rd party libraries that will do this as well.

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.