topic Re: Printing to trays using Crystal Reports 9.0 in Operating System - Microsoft

Printing to trays using Crystal Reports 9.0

Daniel Kent — Mon, 10 May 2004 20:38:24 GMT

I have a web based application created using Visual Studio .NET 2003 which includes Crystal Reports 9. I have set up reports to print to Upper, Middle, and Lower trays. However every printjob thru Crystal goes to the default tray.

I have tested printing to individual trays using word pad and selecting specific trays and it will print to the correct trays. But Crystal won't.

I have also updated the CrystalDecisions.CrystalReports.Engine.Dll as per the known bug ADAPT00102118 form Crystal. This had no effect.

I have played with the paper types etc. but this only forces the a new default tray where the reports are printed.

Anyone have any ideas where to go from here?

Re: Printing to trays using Crystal Reports 9.0

Norman_21 — Mon, 10 May 2004 22:25:27 GMT

Hi,

I don't have experience with Crystal Reports 9 but I would advice you to check their knowledge base Atricles!!!

Hope this help

Re: Printing to trays using Crystal Reports 9.0

Norman_21 — Mon, 10 May 2004 22:30:13 GMT

Try the knowledge Base link and the Forums link:
http://www.businessobjects.com/services/support/default.asp

good luck

Re: Printing to trays using Crystal Reports 9.0

Daniel Kent — Tue, 11 May 2004 09:59:53 GMT

Unfortunately I have poured over their KB for days and everything I've found to date has not helped. Thanks for the suggestion.

Re: Printing to trays using Crystal Reports 9.0

Ganesh Babu — Tue, 11 May 2004 10:08:59 GMT

Hi Daniel,
What is the property u have used to choose the printer tray???

Ganesh

Re: Printing to trays using Crystal Reports 9.0

Daniel Kent — Tue, 11 May 2004 10:18:13 GMT

The PaperSource="Upper" or "Middle" or "Lower" were my preferred sources but I have tried each of the following to no avail:

PaperSource.Upper 1
PaperSource.Auto 7
PaperSource.Cassette 14
PaperSource.Envelope 5
PaperSource.EnvManual 6
PaperSource.FormSource 15
PaperSource.LargeCapacity 11
PaperSource.LargeFmt 10
PaperSource.Lower 2
PaperSource.Manual 4
PaperSource.Middle 3
PaperSource.SmallFmt 9
PaperSource.Tractor 8

Does this answer your question?

Re: Printing to trays using Crystal Reports 9.0

Ganesh Babu — Tue, 11 May 2004 10:33:17 GMT

u r using PrintToPrinter method to print the page or the printer icon in the report???

Ganesh

Re: Printing to trays using Crystal Reports 9.0

Daniel Kent — Tue, 11 May 2004 11:02:58 GMT

PrintToPrinter directly from code in a 2003 .NET browser based application.

Using something like the following:

Report.PrintOptions.PaperSource = PaperSource.Upper
Report.PrintToPrinter(1, False, 0, 0)

Re: Printing to trays using Crystal Reports 9.0

Daniel Kent — Tue, 11 May 2004 11:54:23 GMT

Just for clarification I'm using the latest driver from HP. HP LaserJet 4200 PCL6

Re: Printing to trays using Crystal Reports 9.0

Ganesh Babu — Tue, 11 May 2004 13:26:27 GMT

first thing for debugging check whether the

report.printoptions.papersource is the same value that u have set after printtoprtiner method..

next try instead of the enumerated value Papersource.upper the direct value.. which is i think "1"

PaperSource.Upper 1

Ganesh

Re: Printing to trays using Crystal Reports 9.0

Daniel Kent — Tue, 11 May 2004 13:36:56 GMT

Another quirk is that I can print from trays in my test environment but at production site it does not work. Unfortunately I do not have VS 2003 installed on the production server to debug with.. but I can try to build in a log to check your suggestions.

Re: Printing to trays using Crystal Reports 9.0

Daniel Kent — Wed, 12 May 2004 13:30:24 GMT

Upper 1 syntax does not work. I have tried using CR 10 instead of 9 and the trays work. Thank you for the help.

Re: Printing to trays using Crystal Reports 9.0

Ganesh Babu — Thu, 13 May 2004 11:42:47 GMT

u upgraded to version 10 and the syntax upper 1 - worked??

Ganesh

Re: Printing to trays using Crystal Reports 9.0

Daniel Kent — Thu, 13 May 2004 12:00:33 GMT

No. The original code "Upper" works with CR 10 (trial version) in the test environment. And in fact I now have CR 9 working in the test environment BUT can not get it to work in the production environment. The cost of CR 10 makes that solution impractical. This has to be a DLL version or permissions issue as far as I can tell. I have been working with CR's tech support but haven't gotten anything meaningful from them yet. It is odd because as far as I can tell I am using the same DLLs and have tried to match permissions.. Thanks again!

Re: Printing to trays using Crystal Reports 9.0

Ganesh Babu — Thu, 13 May 2004 12:15:13 GMT

I know.. most of the times we also had the same kind of DLL issue all the times. We use to reinstall them many times and We sometimes check each and every DLL and reregister them to make sure everything is fine.

Ganesh

Note:- Since u r a new user i think U should see this link about this forums
http://forums1.itrc.hp.com/service/forums/helptips.do?#28

Re: Printing to trays using Crystal Reports 9.0

Bill Weber — Thu, 10 Jun 2004 14:33:42 GMT

Any success on specifying the paper trays in Crystal 9 and Visual Studio.NET 2003. I have installed the Hot Fixes from Crystal, but the printer continues to print to the default tray.

Thanks in advance.