Is it a bug or am I missing something.....

[rizvir]

I am using CR8 and VB6 to pass an ADO recordset to a report created using RDC. If my report has only one table then there is no problem and the following code works perfectly:

.....
.....
myrs.open "Select * from MyTable WHERE Myfield='abc'", mycon
set crDbtables = crDatabase.Tables
set crDbtable = crDbtables.Item(1)
crDbtables.SetDataSource myrs, 3
CRViewer1.ViewReport
.....

But if I add another table to the same report (and define or not define a relationship - in both cases) then the same code gives two errors - Unable to access first record! and then SQL Server Error.
I am using MS ADO OLDDB 4.0 connection. I am using a Dynamic Client-Side cursor as advised in a document on the Crystal Decisions web-site.

TIA for any help or suggestions
Rizwan