Report Sequencing

[Mike Mueller]

Vista Business, Access 07, PDF/XPS add in, Acrobat 8

As I got nowhere with merging reports
(I am going to try to use VBA
to script Acrobat to take all of the PDFs generated and make 1 PDF out of
all of them.

Flowchart
1> Print out all reports as PDF
2> Open template.pdf
3> Insert report.pdf files to template.pdf
4> Close template.pdf

Part 1 does work using code based on the following:
For Each obj In dbs.AllReports
strReportName = obj.Name
DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, strFileName,
False
Next obj

Part 2 is not causing any errors at this time

Part 3 is where I have my question-
When Part 1 is executing, it is not saving the reports in any particular
order (that I can tell at least), even though the report names are
alpha-sorted in the correct order (rpt1_xxx, rpt2_xxx, etc). So I am looking
for the best suggestion on how to loop thru the generated reports in
alpha-order so that the output pdf is in the correct sequence

 

[Guest]

Dunno how you tried to merge reports but did you try subreports or put all
the data into one query and use the Grouping And Sorting feature of reports?

 

[Guest]

Mike,
I don't know about doing it in Access, but I use a third party PDF printer
(Freeware) called PDFCreator. It has a built in function for combining
Documents into one PDF. So you can include spreadsheets, Word docs and
Access reports, etc in one PDF
NickX

 

[Mike Mueller]

I have full version of Acrobat, which can do it manually or via batch
processing.
Manual processing is fine on a once a year thing, but tedious on a weekly
basis when dealing with dozens of reports
Batch processing would be fine if the sequence files were not user and
version specific.
I am trying to make this a one button application

 

[Mike Mueller]

I tried merging the reports by using the source reports as subreports. That
approach has worked fine in other instances but did not work here. My
best-imate on the problem is that the subreports are of varying column
counts, and the output report only generates a single column. I also lost
the report headers

 

[Mike Mueller]

At this point I have everything in place except for the 'source' file names.
It is fully operational using hardcoded filenames for the source, I am just
looking for best method of gathering 'source' file names to loop through

Should I go with another table with an order# and filename and then run
through the recordsets or should I use FSO to get the names. Either method I
will need assistance on.