To print crystal reports in such a way that page 1 prints from tray1 and page 2 prints from tray4

Report: Crystal Report 8.0

Printer: HP LaserJet 5200

Summary
I use crystal reports for developing management reports, my manager asked me if it was possible to use crystal reports to read statement details from as400 table and then print the customer statements in such a way that the first page of customer statement prints from Tray1 and the remaining from tray4 of the printer, same condition applies for all other customer statements.  Why tray1, because the pre-printed stationery in tray1 is different to the one in tray4.  I said I dont know because I havent come across such a situation, but would enquire.
josypAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

peter57rCommented:
I don't believe it is possible to switch printer trays within a single report.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
josypAuthor Commented:
I don't know any thing about PCL (Printer Control Language) coding, but is it possible to use such codes in crysal report design view and print as per the request?
0
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
See http://www.kenhamady.com/bookmarks.html for a list of 3rd-party Crystal Reports tools.

My Visual CUT software allows you to control the paper tray source for each page via Crystal formulas embedded in the report or via page range directives in a command line argument.  The automated process first exports to pdf and then splits the printout of the pdf across multiple printer trays.  

For detail, you can download the user manual from http://www.milletsoftware.com/Visual_CUT.htm
and see the sections on:
Using PDF_Print_Split
and      
Using PDF_Print_Split_Tag      
 
hth,
- Ido
0
mlmccCommented:
That is the only way other than to write your own application to do what Visual Cut does.

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.