Crystal Problems still being a pain

[Zarmain]

Guess what? I still need help (both with crystal and medical)...

For some reason or another a set of quite complex reports are failing to print when called from VB. Everything seems to be fine - the code runs, the little dialog box appears but nothing comes out of the printer.

The data is stored in an SQL7 server and we are using version 7 of crystal, can anybody out there (not Mulder) shed some light on what is maybe going wrong, is their anything blindingly obvious that we are missing? Below is an example of the fairly simple code that we are trying to use to print the reports.

CrystalReport1.Connect = "odbc;driver={SQL Server};server=<Server Name>;uid=<Username>;pwd=<password>;database=<DB Name>"
CrystalReport1.Destination = crptToPrinter
CrystalReport1.CopiesToPrinter = 1
CrystalReport1.ReportFileName = "<Report Path & filename>
CrystalReport1.PrintReport


Thanks in advance.

Ian Duckhouse

[Serge]

This might happen if you (or anybody else) created or changed this report with no printer installed. Here is an example.

If you open, for example, already created report in Crystal Report Designer and Designer finds that you don't have any printer installed, it disables print feature. So, when you distribute this report to a client, it won't have print functionality.

Possible resolution:

Open this report in Crystal Report Designer.
From the File menu select Printer Setup. Make sure that No Printer checkbox is unchecked.


Hope this helps,