server has not yet been opened 1

[lunchbox88]

Crystal 8.5, Access, VBA...

I can open a report in the CRViewer where the tables are on a SQL Server, but if I want to open a report where the tables are in an Access DB on my local machine, I get the "Server has not yet been opened" error. I'm new to using the CRViewer, and not quite sure what's wrong, or what the settings should be. There's no username or password for the database because it's on my local machine.

any help is greatly appreciated.

Thanks!

 

[vidru]

Can you post the code you're using, as well as your Crystal version, and the method of connectivity the report(s) are using (Native, ODBC, ADO, etc.)?

-dave

 

[lunchbox88]

Set crxRpt = crxApp.OpenReport("c:\reports\report1.rpt")
'Setting the ReportSource of the CrViewer control to the Report object
Me!CRViewer5.ReportSource = crxRpt
'view the report.
Me!CRViewer5.ViewReport
'do events first before continuing in order to avoid application crashes
While Me!CRViewer5.IsBusy
    DoEvents
Wend

The reports I'm building in CR 8.5

 

[vidru]

What about the connectivity?

If the report was designed against a SQL datasource, it will try to connect to the same server/db that it last connected to, unless told to do otherwise. Open the report in the CR Designer, and use Set Location (Database menu > Set Location) to point the report to your Access db, save it, then try it again with your code above.

-dave

 

[lunchbox88]

Thanks! That worked like a charm.