• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2279
  • Last Modified:

deploying vb6 application with a CrystalActiveXReportViewer control

I using vb6 and crystal report XI to create a network based win Apps. I created .rpt file, and using ODBC DSN connection to sql server on my dev machine, everything is running fine, I can view data result using crystal report viewer. After I created a installation package (using Package Wizer),  and installed the apps on my client machine, it seems that vb App can talk to sql server backend, but there is nothing shows on crystal reprt viewer (the control leave blank white). I also created ODBC DSN  on my client machine as the same as on dev machine.
I have added required .dll file when created package
Can any one provide me the solution, please help. it is very urgent, and i am new for crystal report.

thanks indeed!

Lucy
0
Lucy1965
Asked:
Lucy1965
  • 5
  • 3
1 Solution
 
MilanKMCommented:
Hi Lucy,

All I can help u in this section is just followings. Try out this, open Crystl32.dep in Notepad or a similar text editor and modify the section:

[CRPE32.DLL]
Dest=$(WinSysPath)
Uses1=CRPE32.DLL
Uses2=

So that it reads:

;[CRPE32.DLL]
;Dest=$(WinSysPath)
;Uses1=CRPE32.DLL
;Uses2=

Also check whether the ActiveX is correctly registered. Try out latest hotfix & updates here: http://support.businessobjects.com/fix/hot/mhf/crystalreports.asp

Anyways if these doesn't solve your problem I'll suggest you to put a pointer question of 20 points in the VisualBasic & CrystalReport T.A. I think you'll get better responses there.

Thanks
MilanKM
0
 
Lucy1965Author Commented:
Thank you very much for replying my question.
 the below is the Crystl32.dep openedd in Notepad, I did not see  CRPE32.DLL.
Please let me know what should i do.
Also, I am new to EE, and I really need help to get the job done.

; ------------------------------------------------------------------------------
; Dependency file for setup wizards.


[Version]
Version=6.1.0.609


; ------------------------------------------------------------------------------
; Dependencies for CRYSTL32.OCX


[CRYSTL32.OCX]
Dest=$(WinSysPath)
Register=$(DLLSelfRegister)
Version=6.1.0.609
Uses1=CRPE32.DLL
Uses2=COMCAT.DLL
Uses3=OLEPRO32.DLL
Uses4=


[COMCAT.DLL]
Dest=$(WinSysPathSysFile)
Register=$(DLLSelfRegister)
Uses1=


[OLEPRO32.DLL]
Dest=$(WinSysPath)
Uses1=
0
 
MilanKMCommented:
Ok, thats fine. Now it shows what are the dependencies of CRYSTL32.OCX. Those are as follows:~

CRPE32.DLL
COMCAT.DLL
OLEPRO32.DLL

That means CRYSTL32.OCX needs those three dlls to run. Just copy those files along with the CRYSTL32.OCX to C:\Windows\System32 for WinXP folder or if Win2000 it may be WinNT\System32.

I think it will work for u.
MilanKM
0
Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

 
Lucy1965Author Commented:
Hi,
I have all those files in system32 directory, even on my client machine (2003).

I have created report using XI version (update from CR7) and using ODBC Connect to sql server.
 the vb apps using CR7 before
 on my code:

     conn.Execute sSql, lAffected
      sReportName = "\reports\MoveReport.rpt"
         
        If lAffected > 0 Then
       
         Set rdApp = CreateObject("Crystalruntime.application.11")
     
         Set rpt = rdApp.OpenReport(App.Path & sReportName)
       
           Me.CrystalActiveXReportViewer1.ReportSource = rpt
           Me.CrystalActiveXReportViewer1.Refresh
           Me.CrystalActiveXReportViewer1.ViewReport
           CrystalActiveXReportViewer1.Visible = True
   
           Set rdApp = Nothing
           Set rpt = Nothing
     
It is ok on my  developer machine, just don't work on client machine. there is blank on CrystalActiveXReportViewer. and I created a ODBC DSN same as on my developer machine, using sa as user.
0
 
MilanKMCommented:
Hi Lucy,

In this section I think your question isn't quite a right one. I think you'll get more response it you post/move this question to the VisualBasic or CrystalReport T.A. You can also create a 20 point at those Topic Area containing link to this question.
Links to those T.A. as follows

http://www.experts-exchange.com/Databases/Crystal_Reports/
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/

I think you'll get more responses in those T.A.

Hope u get solution soon
MilanKM
0
 
MilanKMCommented:
On the pointer question put subject & question body as follows. And the pointer should be not more than 20pt. Experts will answer on the main question.

Sub:
-----
>> 500 pt (Pointer to Crystal Report question)

Question body:
-----------------
http://www.experts-exchange.com/Programming/Software_Design/Q_21817200.html
0
 
MilanKMCommented:
Hello,

if there is any problem in creating pointer question for this then pls reply.

Thanks
MilanKM
0
 
Lucy1965Author Commented:
Sorry wasn't reply back right away, busy on problem solving. finally i solved this problem. CRXI need using module to support client machine  run time  CR .dll requireing, and have to using VSINS1.1 to create module for CRXI installation.
in this case, when deploying Win apps along with CRXI, can't using PDW.
Again, thank you very much for the help!

Lucy
0
 
GranModCommented:
PAQed with points refunded (500)

GranMod
Community Support Moderator
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now