Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Business Objects: Crystal Reports 4 Other topics FAQ

CR Printer Dialog Box

Selecting a different tray to print from through CR and VB by bburnell
Posted: 13 Jun 02

*NOTE* MyRpt is generic for your instance of the CR report you wish to print from.

To set CR to print to the tray that is the printer default you do this:

 MyRpt.PaperSource = Printer.PaperBin

*NOTE* Printer.PaperBin is usually 7 (Auto Select) by default.

You can also set papersource to the following properties (a full list is at the bottom):
Auto Select = 7 (or) crPRBinAuto
Upper Tray  = 1 (or) crPRBinUpper
Lower Tray  = 2 (or) crPRBinLower
Middle Tray = 3 (or) crPRBinMiddle
Manual Feed = 4 (or) crPRBinManual

An example to print to the middle tray would be:
MyRpt.PaperSource = 3
MyRpt.PaperSource = crPRBinMiddle

Check out these 2 links from Crystal Decision's Knowledge Base for more details:

The following is very  important!
"If the SelectPrinter method of the Report object is being used to change the printer for the report, the 'PaperOrientation' and 'PaperSource' properties must be set after invoking the SelectPrinter method. If the 'PaperOrientation' or 'PaperSource' property is set before the SelectPrinter method, then paper tray or orientation settings are overwritten with the new printer's settings."

Here are all the codes:
 crPRBinUpper - 1
 crPRBinLower - 2
 crPRBinMiddle - 3
 crPRBinManual - 4
 crPRBinEnvelope - 5
 crPRBinEnvManual - 6
 crPRBinAuto - 7
 crPRBinTractor - 8
 crPRBinSmallFmt - 9
 crPRBinLargeFmt - 10
 crPRBinLargeCapacity - 11
 crPRBinCassette - 14
 crPRBinFormSource - 15

*NOTE* There is no 12 or 13.

I was emailed this question and I'm currently doing it for work. I thought I would share the information.
Brett (smsforce)

Back to Business Objects: Crystal Reports 4 Other topics FAQ Index
Back to Business Objects: Crystal Reports 4 Other topics Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close