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
