server has not yet been opened...

[rainbowrabbit]

Having trouble using the Crystal Viewer activex object in Access. I have had a similar problem with this connecting to Oracle to export report data and I got around it by using the following;

crxReport.Database.Tables(1).SetLogOnInfo "", "", "", ""

and not the logonserver method.

I know have the same problem with a viewer I have embedded into Access to view a report. My code is as follows;

Const strReportFile As String = "P:\M.I.T\Projects\Excellence in Cities\EIB Data\4_2003 Autumn\DataReturnStatus.rpt"
Public crxApplication As New CRAXDRT.Application

' Declaration of the report object
Public crxReport As CRAXDRT.Report

Private Sub Form_Open(Cancel As Integer)
Set crxReport = crxApplication.OpenReport(strReportFile)
crxReport.Database.Tables(1).SetLogOnInfo "", "", "", ""

Me!ctrlViewer.ReportSource = crxReport
Me!ctrlViewer.ViewReport

End Sub

Whatever I do I get the same annoying message and no report displayed??

 

[rainbowrabbit]

sorry version info..

crystal 8.5
access 2000