We are using GE's iFix application which supports VB. We would like to run some Crystal Reports that I have developed from a link/button in iFix but don't know how to make the call. We can get a reports parameter page to pop up using the following code, but then get an error on authentication to the database and don't know how to call the viewer. The ODBC data source is setup on the machine same as in the report. Are we missing a call to set the database security and how do we get the report to popup in the report viewer window?

Private Sub CommandButton2_Click()
Dim CrApp As CRAXDRT.Application
Dim CrRep As CRAXDRT.Report
Set CrApp = New CRAXDRT.Application
Dim strquery As String

Set CrRep = CrApp.OpenReport("D:\Reports\ReportName.rpt")
CrRep.DiscardSavedData

...

Set CrRep = Nothing
Set CrApp = Nothing

End Sub

Anyone know how to make this call work to run and view the report would be very much appreciated.

Jay Tyo

You can get the help files and other information here: https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads.

-Dell