Combine several reports into 1 print job

evilman

Registered User.
Local time
Today, 09:21
Joined
Apr 25, 2003
Messages
31
Hi,
as I stated in the subject, I would like to combine several reports into 1 report.
I did a google groups search, however, but I couldn't find any good solution.

The most popular was the subreport, but I can't do this, since the print order is extremely complicated and chaotic. Each page would require a subreport... and there's about 100 pages.

Then many people recommended to convert the reports into a single PDF document. It's a good idea, but we can't have Acrobat installed on our computers. I'm in a big company, so having the permission to get anything installed on a single computer takes months... and since my application will be distributed around in the company, well it will take months for it to work on my coworker's computer.

And finally, there is this solution from Mr. Lebans... convert the reports into a Word or WordPad document. It's a good idea, but the exportation to Word does not work at all. The WordPad exportation works, but the report is out of the page bound, for some reason. Another problem is that I dont think Word supports both Landscape and Portrait orientations in 1 document (some of my reports are in landscape, while some others are in Portrait...) however Acrobat PDF does support that.
Here's the URI of Mr. Lebans' Report to Word converter: http://www.lebans.com/ReportUtilities.htm

Any better idea? like using GDI to create my own print job?

Thanks.
 
Last edited:
Hi

If I understand you correctly, you want to print several reports in a particular order to give 1 printed output.

To do this I would put a button on a form to call the first report for printing, then edit the code behind the button to call each of the reports in the correct order. This should give you all the reports printed in the correct order.

Hope this helps

Sue.
 
yes that I precisely what I want.

I use a Queue class to create a list of reports.
it works perfectly, however the problem is printing multiple copies.
if I use domcd.printout, it will print several copies of each report, but they won't be printed in the correct order. I cant bring this into words.. i'll show you.

say I want to print reports 1 2 3 in the following order:
3 1 2
but I need 3 copies... using printout, i would get:
3 3 3 1 1 1 2 2 2
but thats not what I want.. what I need is:
3 1 2 3 1 2 3 1 2

I could do a loop that reads the queue 3 times, but I dont like this.
 
Hi

I have created a dummy database with 1 form containing a text box to define how many copies of the entire report are required, and a button to print the reports. The database also contains 3 reports with just a text box.

the code behind the button on the form is:

Dim counter As Integer

Dim stDocName As String
For counter = 1 To Me.NoofCopies
stDocName = "Report1"
DoCmd.OpenReport stDocName, acNormal
stDocName = "Report2"
DoCmd.OpenReport stDocName, acNormal
stDocName = "Report3"
DoCmd.OpenReport stDocName, acNormal
Next

This will repeat the print job the number of times defined in the text box.

The database is attached in 97 format as I don't know which version you are using.

I hope this is what you want.

Sue
 

Attachments

Hi! Thanks for taking your time and writing this example.
Well this is exactly what I did. I use a listview with checkboxes to let the user choose which report he wants, plus he can drag the listview items up and down, allowing him to change the print order.

Well.. it works.. yes, but it's not efficient... because there's wasted CPU time. If all the reports are generated once, and printed once, I dont see why I have to redo the same operation over and over again.

Then again, maybe it's just me who's a bit picky.
 
Hi,

I was wondering if you ever came up with a better solution to this printing issue.

I have a similiar issue and the CPU speed is the issue.

Thanks,
 
no, unfortunatly, we have not found a way to fix that problem.
printing is still as slow as ever.

as soon as a project gets too big, it tends to slow down.. access limitation unfortunatly
 

Users who are viewing this thread

Back
Top Bottom