[RESOLVED] How to deploy crystal report 9 on client machines

[kamran]

I have developed an application in vb6 which also generates reports using crystal report 9. It all works well on the developer machine but when i want to deploy it on client machine it gives an error. I know that there are some dll reuquired, could any one please tell me what are the exact dll required. Also i want it to make it run on win 98.

Thanks

[RobDog888]

Welcome to the Forums.

You should have the special help file in -
?:\Program Files\Seagate Software\Crystal Reports\Developer Files\Help\Runtime.hlp

In this help file it will list out all the CR dlls and ocxs required depending on the references, functions, and controls used in your program.

[kamran]

Thanx for the quick reply. I have seen that file before posting this message and i have tried to register those files but the problem is that one of the dll which i try to register doesn't give me a message that it is registered successfuly or not. I dont remember the name of that file. I was wondering if some one already have a package which i can use to deploy the files.

thanks

[RobDog888]

If you gather all teh dlls and ocxs it will be about 20Mbs. I highly doubt that you want to deploy all files. This si what the runtime file is to help you with. There is no way for anyone to tell you all the dependancies you need without your entire app's source code.

[kamran]

oh ok i get the point, i would have a more closer look as to what i need before deployment. How ever i just made a small check with this statement Set crystal = New CRAXDRT.Application. I commented all my code after this line and for this i registered the required dll but it failed.

I am not creating the crystal reports in the vb designer. I just call it and display it in a form using crviewer.

[RobDog888]

Yes, I have done that one before. It doesnt need that many dependancies. Do you have error trapping in your app so you can get the most descriptive error message? Also, if you are supporting the export button on the viewer control then there are a few more dlls to include as there are one or two for each export type.

[kamran]

The code below is what i am using and i am not using the export button.

Dim conn As New ADODB.Connection
    Dim rs As New ADODB.Recordset
    Dim crystal As CRAXDRT.Application      'LOADS REPORT FROM FILE
    Dim Report As CRAXDRT.Report            'HOLDS REPORT
    
    Set crystal = New CRAXDRT.Application
    
    CRViewer.DisplayBorder = False          'MAKES REPORT FILL ENTIRE FORM
    CRViewer.DisplayTabs = False            'THIS REPORT DOES NOT DRILL DOWN, NOT NEEDED
    CRViewer.EnableDrilldown = False        'REPORT DOES NOT SUPPORT DRILL-DOWN
    CRViewer.EnableRefreshButton = False    'ADO RECORDSET WILL NOT CHANGE, NOT NEEDED
     
    conn.Open ConnectionString
    
    rs.Open "SELECT * FROM ViewLoanSetCheckSheet where LoanSetID=305", conn, adOpenStatic, adLockReadOnly
     
             'MANAGES REPORTS
     
    Set Report = crystal.OpenReport(App.Path & "\CrystalReports\Report1.rpt")  'OPEN OUR REPORT
     
    Report.DiscardSavedData                      'CLEARS REPORT SO WE WORK FROM RECORDSET
    Report.Database.SetDataSource rs             'LINK REPORT TO RECORDSET
     
    CRViewer.ReportSource = Report              'LINK VIEWER TO REPORT
    CRViewer.ViewReport                         'SHOW REPORT
     
    Do While CRViewer.IsBusy              'ZOOM METHOD DOES NOT WORK WHILE
       DoEvents                          'REPORT IS LOADING, SO WE MUST PAUSE
    Loop                                  'WHILE REPORT LOADS.
     
    CRViewer.Zoom 94
     
    rs.Close                            'ALL BELOW HERE IS CLEANUP
    Set rs = Nothing
     
    conn.Close
    Set conn = Nothing
     
    Set crystal = Nothing
    Set Report = Nothing

[RobDog888]

For the viewer control you need several files. Find the index page titled: Method Used to Access the Crystal Report Engine

Under this page is a listing of Method, Project Reference Names, and Description columns. This is your starting point. Click the links on the method column that are used in your references or controls. There are several conditions if you need to add each, described on each of the links destination page.

I can not post the contents as they are copyrighted.

[kamran]

you have been a great help...Dependency Files for Craxdrt9.dll...i think i should register the associated files with it..a week ago i did follow this and when i tried to register one of these dll file...i got no message that it was either registered or not...i dont exactly remember the dll file probably it was crqe.dll or usp10.dll..

[RobDog888]

I only have v. 8.5 developer and I cant find crqe.dll. I did find the crpe32.dll and crpe.dll Crystal Rpeorts Print Engine used for printing from code in vb.

[kamran]

did you ever had any problem in registering one of the files...

[RobDog888]

Yes, but I just ignored the error and it seem to be fine. Been running at the clients site for 9 months.

[kamran]

alrite i'll give it a go...if i find some error, i know where to look...thanks mate

[RobDog888]

No problem. glad to help
I didnt add those problematic dependancy files and did a simple copy/paste into the appropriate folder. The ones that registered correctly I added to the setup package.

[tansarbh]

You must have created a reference to crystal report in your project right? So create Application Package and it will include the required dlls by it self and then install it on client machines.

Should work.

[RobDog888]

Its not that simple with CR. With a single reference you need to include several dlls. If you use the CR Viewer control you neeed allot more. If you use just the print engine you need others. This is why CR created the runtime help file.