Click to See Complete Forum and Search --> : Crystal Reports in vb.net


balajigr
March 11th, 2003, 11:26 PM
Hello,

I have shown below how i am calling the .rpt file.This works fine in the system where i create the setup of my application.
When this setup is copied and installed on a different system.
This gives me a "Query Engine Error"
Could you help me with this.

Code used....
objCrRptDoc.Load(Application.StartupPath & "\rptCallDetails.rpt", _
CrystalDecisions.[Shared].OpenReportMethod.OpenReportByDefault)
CryRepVwCallDetails.ReportSource = objCrRptDoc

OR

objCrRptDoc.Load("C:\Program Files\Kshema Technologies Ltd\VeDA0.1\rptUsersDirectory.rpt", _
CrystalDecisions.[Shared].OpenReportMethod.OpenReportByDefault)
CryRepVwCallDetails.ReportSource = objCrRptDoc


Both the above code didnt work for me.

-Balaji

riteshtandon
March 11th, 2003, 11:36 PM
I havent worked on .NET but what i feel is that some file DLL or OCX is missing in your setup which is causing the Error.


Ritesh

balajigr
March 11th, 2003, 11:45 PM
Originally posted by riteshtandon
I havent worked on .NET but what i feel is that some file DLL or OCX is missing in your setup which is causing the Error.


Ritesh

Hello,

I hve used crystal reports in my vb.net application.and have created a setup of it.but when i install the setup in a different system, when show report menu is clicked gives me a "query engine error"
could you let me know what all merge modules should i inculde or is there any other things i have to take care.

bringing of this thread i have shown i how i have loaded the report!

thanks
-balaji

riteshtandon
March 12th, 2003, 04:54 AM
This is certainly a problem of incorrect installation of crystal report. check CR documentation to see what all files(DLL & OCX) are needed to access the database, and whether u have added them to your installation.

Or try to use the CR designer inside of VB

Ritesh
tandonritesh@yahoo.com

balajigr
March 12th, 2003, 10:26 PM
Hello,

had to include some merge modules.

Thanks.

Originally posted by riteshtandon
I havent worked on .NET but what i feel is that some file DLL or OCX is missing in your setup which is causing the Error.


Ritesh

riteshtandon
March 12th, 2003, 11:25 PM
whats merge modules

balajigr
March 12th, 2003, 11:57 PM
when using crystal reports and building a setup file u need to include the follwong merge modules and dlls

vc_crt.msm
vc_stl.msm

dlls should go into the system folder
msvcp70.dll
msvcr70.dll

merge modules contain some dependency dlls
provided by microsoft