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
Lucy1965Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming Theory

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.