'server has not yet been opened' error :RESOLVED

[Shafan]

Hi,
I'm trying to open a form with the report viewer control on it to view a report.
The report data is set using the SetDataSource method:
rptCourses.Database.SetDataSource rst, 3

The report's viewing form Load event is:
CRViewer1.ReportSource = rptCourses
CRViewer1.ViewReport

I get a 'server has not yet been opened' error when trying to execute the 'CRViewer1.ViewReport' statement.

I have another report in the same project (not using SetDataSource) that runs just fine, and a report on another project that does use SetDataSource that uses more or less the same code and runs fine.

I'm using VB6 and CR 8.5 on winXP machine

Any ideas? Help would be appreciated.
thanx

[SkiNLaB]

how does the recordset behave if u try and use it in your visual basic code?

eg.

while rst.eof = false
debug.print rst(0)
rst.movenext
wend

[Shafan]

Found what was the problem - one field was missing in the dynamic ADO recordset I was passing compared to the one the report was built on.

Thanx.