'Merge' Reports

M

Mike Mueller

System: Access 2007 on Vista Business

Background:
User created a well maintained db in Lotus Approach. He does not have the
ambition to learn how to redo in Access. This db is updated and maintained
properly, and monthly there are reports run on it using ~ 50 queries to
generate the ~75 reports. What has changed is that these reports must also
be converted to PDFs, and Approach is slower than pondwater creating them.
I have worked with him and now his macro that generates his reports also
creates a csv file. I have recreated the queries & reports in Access, and I
am using linked tables to his CSV files for the data. I have also been able
to reduce the amount of reports to match the queries. I am using the xls/pdf
addin from MS to save the reports to PDF, as it is quicker than printing to
Acrobat and takes less than 5 minutes. After the PDFs are generated, I need
to merge them into 1 big PDF.
What I would like to do is to get away from then opening in Acrobat and
inserting pages either manually or via there batch processing.

Is there a way to 'merge' all of the reports into 1 large one, and then send
it to pdf?
 
M

Mike Mueller

While I did some googling, I found what I hoped to be an answer. If the
reports are based on the same data, it is possible to use the reports as
subreports. Tried it, but I do not get the report header, nor the columns
(some are 2 columns, some are 3)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top