[SOLVED] PrintOut method question

[JackV]

In a VB 6 application I am automating a Crystal 8.5 report. More specifically I am repeatedly passing a recordselection formula to it and then sending the report to the printer. What this does is print out each group into their own print job. I need to do this so our printer can insert a sheet (different color paper) in between each job. This will make it easier to collate the report later. The whole report is approximately 17000 pages with each group being about 20-30 pages.

I get a "Server has not yet opened" error whenever I call the PrintOut method while the prior job is still spooling. Right now I'm reuseing both the application and report object as I loop through the recordset which is the basis of the selection formula values that I am passing. Can what I'm proposing be done?

Thanks,

Jack

[brucevde]

I have just completed the exact same project, although my report for each group is typically only two pages. Everything worked well, so I think what you are trying to do is correct.

I never tried the following methods, in theory they should work.

You may need to wait until the group has finished printing. Try using the Report.PrintingStatus.Progress property. If it is still InProgress then maybe wait a few seconds.

Another option would be to use two Report objects, ie open the report twice. While one is printing you can start the second one for a different group. Hopefully by the time the second one has been sent to the printer you can then use the first one for the next group.

HTH

[JackV]

Thanks for response brucevde! Actually about an hour ago I got it working by releasing and then resetting the report object via the application objects OpenReport method between each call to the PrintOut method.