I have a client that want to generate letters with up to nine pages from the database we built for them.
Each page contains some date from our DB but each page also contains paragraphs of non repetative text. This is a law firm.
I development, I created all of the pages as individual reports with the intent of combining them onto one report for producstion. I planned to do this by cutting and pasting from the individual reports/pages into one consolidated report, with a hard pagebreak between the pages.
That didn't work. Even with page break controls on the report the page size will not expand enough to get more than a couple pages on.
So for right now I have the app setup to print all nine pages/reports when the option to print the letter is selected. The reports are created in preview mode. This creates a mess on the user screen. Once the user verifies the content they have to print nine individual pages to get the complete output. Not very acceptable, especially when they do these in batches.
Is there a way to combine all the pages onto one report that I just don't know about?
Secondly, if I have to go directly to the printer with these reports rather than put them up in preview mode: The user may not want the reports to go to their default printer. Is there a way for the user use do that in such a way that the user can select which printer to send them to.? Although even that would be a pain since they would have to select it nine times.
Any better options? We;ve had some unpleasant experiences with Mail merges that's why I'm trying to stay away form that option.