I'm using vb 6 and the crystal reports ocx, which connects to a sql server 2000 database. And when I try to directly print the report, it gives me an error "run - time error 20500 not enough memory for operation"
The program works on my development computers, but just not on client computers when I install it.
I searched crystals site and found that crystal is trying to connect to the wrong database, but crystal's site only tells how to fix it with accessing a access db, not sql server. Any one else run into this problem and know of a fix?
Thanks
here's the code that calls it:
CrystalReport1.ReportFileName = App.Path & "\PWMS_Pallet_Tag.rpt"
CrystalReport1.ParameterFields(0) = "PalletIDTagInput;" & palletTagID & ";TRUE"
CrystalReport1.ParameterFields(1) = "ShiftCounter;" & shiftCounter & ";TRUE"
'print report here
CrystalReport1.CopiesToPrinter = 3 'print 3 copies of this report
CrystalReport1.Destination = crptToPrinter
CrystalReport1.action = 1
The program works on my development computers, but just not on client computers when I install it.
I searched crystals site and found that crystal is trying to connect to the wrong database, but crystal's site only tells how to fix it with accessing a access db, not sql server. Any one else run into this problem and know of a fix?
Thanks
here's the code that calls it:
CrystalReport1.ReportFileName = App.Path & "\PWMS_Pallet_Tag.rpt"
CrystalReport1.ParameterFields(0) = "PalletIDTagInput;" & palletTagID & ";TRUE"
CrystalReport1.ParameterFields(1) = "ShiftCounter;" & shiftCounter & ";TRUE"
'print report here
CrystalReport1.CopiesToPrinter = 3 'print 3 copies of this report
CrystalReport1.Destination = crptToPrinter
CrystalReport1.action = 1