Printing Crystal Reports from Visual Basic while controlling printer settings

We have several Crystal Reports that need to be printed out from different trays and then stapled together. We are using Visual Basic 6, Crystal Reports 11 and a Ricoh multifunction printer.

Is using PJL an option, how would you use this with crystal reports. I was not able to find a good way to print the crystal report to a file to then add PJL commands.

We also purchased the API from ricoh, unfortunately it does not support this printer. Even so If I set the printer on one that is supported and then print the crystal report the settings are not used for the CR (The API works by setting WINAP).

Any help or suggestions?
esiexcAsked:
Who is Participating?
 
Ido MilletConnect With a Mentor Professor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
If the stapling requirement is removed, you can easily send each report to a different printer tray.

If you need to split the printout of a single report across different paper trays (1st page to Tray 1, Pages 2 to 3 to Tray 3, ...), Consider a 3rd-party tool as a solution (for a list of such tools, see http://www.kenhamady.com/bookmarks.html).  My Visual CUT software provides two approaches that allow you to automate such a process.  

- Ido
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Are you willing to let go of the automated stapling requirement?
0
 
esiexcAuthor Commented:
We need as many of the requirements done as possible, so if there is no way to do the stapling I would still be interested in how to accomplish the tray control.
0
 
esiexcAuthor Commented:
Thanks, If I cannot find a way to staple I will look into that.
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.