The database I created allows the user to choose which reports they want or do not want. I need to find a way to merge the reports they choose into one document in a print preview / printing. Currently right now if they choose the print preview it opens up multiple previews for each report rather then one huge report of all merged docs.
Multiple chosen reports print preview / prints as 1 document, Office 2003
- Thread starter brad6582
- Start date
I created a program that creates multiple differnt types of documents. I set up a form where they can check the documents they need and not check the ones they dont need. Right now I created a macro that prints and anouther macro that does a print preview on the ones they have selected but they all open in seperate reports. I am trying to somehow merge the selected reports into 1
- Local time
- Today, 14:42
- Joined
- Aug 30, 2003
- Messages
- 36,272
If they're actually different documents, as opposed to the same document with different data, it will be problematic to mix and match them into one. The only way I can think of offhand would be to have a "master" report that had subreport containers for the others. You'd then populate each subreport with the appropriate selected report as the report opens. I've never tried it and frankly not sure how well or even if it would work. Trying to combine reports with different structures and data sources into one will be tricky.
