kmdfaizal
Aug 24th, 2000, 05:50 AM
Dear All,
I have crystal report 4.6 for VB I have used my form the ActiveX control of crystal report and I given the Report file name also in crystal report property.
Then I am using SQL query for making report I given in my the following code. In Cmd_Print click event.
CrystalReport1.SQLQuery = "SELECT labinfo.`typeofcert`, labinfo.`date`, labinfo.`certificate_no`, labinfo.`nameofpat`, labinfo.`sex`, labinfo.`nation`, labinfo.`pliqamaissue`, labinfo.`daiqama`, labinfo.`plpassport`, labinfo.`ppdateissue`, labinfo.`profication`, labinfo.`sopnsername`, labinfo.`address`, labinfo.`city`, labinfo.`telephone`, labinfo.`fax`, labinfo.`clinicalcheck`, labinfo.`xray`, labinfo.`throatswab`, labinfo.`stoodcutture`, labinfo.`malaria`, labinfo.`urine`, labinfo.`bloodtype`, labinfo.`pregancy`, labinfo.`hiv`, labinfo.`hepaC`, labinfo.`hepaB`, labinfo.`iqamano`, labinfo.`sponserno`, labinfo.`passportno`, labinfo.`dateofbirth` From `labinfo` labinfo where {labinfo.certificate_no} = '10/20/2000' “
CrystalReport1.Action = 1
When the CrystalReport1.Action true event is execute the following error is coming
Run time Error “20536” Incorrect Log on Parameter
Let me know what else I have to give in my VB crystal report ActiveX control pro.
Looking forwarded your reply
Thank with Regards
Faizal
I have crystal report 4.6 for VB I have used my form the ActiveX control of crystal report and I given the Report file name also in crystal report property.
Then I am using SQL query for making report I given in my the following code. In Cmd_Print click event.
CrystalReport1.SQLQuery = "SELECT labinfo.`typeofcert`, labinfo.`date`, labinfo.`certificate_no`, labinfo.`nameofpat`, labinfo.`sex`, labinfo.`nation`, labinfo.`pliqamaissue`, labinfo.`daiqama`, labinfo.`plpassport`, labinfo.`ppdateissue`, labinfo.`profication`, labinfo.`sopnsername`, labinfo.`address`, labinfo.`city`, labinfo.`telephone`, labinfo.`fax`, labinfo.`clinicalcheck`, labinfo.`xray`, labinfo.`throatswab`, labinfo.`stoodcutture`, labinfo.`malaria`, labinfo.`urine`, labinfo.`bloodtype`, labinfo.`pregancy`, labinfo.`hiv`, labinfo.`hepaC`, labinfo.`hepaB`, labinfo.`iqamano`, labinfo.`sponserno`, labinfo.`passportno`, labinfo.`dateofbirth` From `labinfo` labinfo where {labinfo.certificate_no} = '10/20/2000' “
CrystalReport1.Action = 1
When the CrystalReport1.Action true event is execute the following error is coming
Run time Error “20536” Incorrect Log on Parameter
Let me know what else I have to give in my VB crystal report ActiveX control pro.
Looking forwarded your reply
Thank with Regards
Faizal