sonofsita
September 11th, 2001, 10:40 AM
Database Oracle 8.1.6
Reports Crystal 8.5
VB 6 with SP 5
The following code is used to call a report
frmRequest.CrystalReport1.DiscardSavedData = True
frmRequest.CrystalReport1.ParameterFields(1) = "Change Request No;1;false" 'parameter field name={?change request no}
frmRequest.CrystalReport1.ParameterFields(0) = "Change Request No;1;false"
frmRequest.CrystalReport1.Action = 1
after duly populating the connect and reportfilename properties.
the crystal report comes up asking to feed the parameter field and after submitting the parameter the report crashes with runtime error 20599 can not open sql server.
can some body help me out of this
(Surprisingly I am able to open the report with setting any parameter which is not my requirement as I wanted a single wished record)
sonofsita
Reports Crystal 8.5
VB 6 with SP 5
The following code is used to call a report
frmRequest.CrystalReport1.DiscardSavedData = True
frmRequest.CrystalReport1.ParameterFields(1) = "Change Request No;1;false" 'parameter field name={?change request no}
frmRequest.CrystalReport1.ParameterFields(0) = "Change Request No;1;false"
frmRequest.CrystalReport1.Action = 1
after duly populating the connect and reportfilename properties.
the crystal report comes up asking to feed the parameter field and after submitting the parameter the report crashes with runtime error 20599 can not open sql server.
can some body help me out of this
(Surprisingly I am able to open the report with setting any parameter which is not my requirement as I wanted a single wished record)
sonofsita