Crystal Reports in vb.net

[balajigr]

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]

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]

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]

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
[email protected]

[balajigr]

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]

whats merge modules

[balajigr]

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