I'm new to these forums so I apologize if I'm posting in the wrong section.
I'm running multiple reports that I print to PDF using a freeware PDF printer (PDF995). These reports are ran on a weekly basis and will always be merged into one document. Currently what I have setup is a macro to print all the reports to individual pdf files, then I use PDFEdit995 to merge them all to one document. Long and short of it is that it takes no time to run the reports, what is time consuming is merging them and arranging them all into a single pdf file and I Was wondering if there is any kind of script or advice that can be provided (or point me in the direction of) that will print and merge these files into a single pdf?
I've also attempted making the reports all sub-reports on a new report however I'm having issues with spacing as some reports aren't increasing in size even though they are set to, and some are overlapping other reports.
Any help is appreciated!
I'm running multiple reports that I print to PDF using a freeware PDF printer (PDF995). These reports are ran on a weekly basis and will always be merged into one document. Currently what I have setup is a macro to print all the reports to individual pdf files, then I use PDFEdit995 to merge them all to one document. Long and short of it is that it takes no time to run the reports, what is time consuming is merging them and arranging them all into a single pdf file and I Was wondering if there is any kind of script or advice that can be provided (or point me in the direction of) that will print and merge these files into a single pdf?
I've also attempted making the reports all sub-reports on a new report however I'm having issues with spacing as some reports aren't increasing in size even though they are set to, and some are overlapping other reports.
Any help is appreciated!
