Can I make reports using ADO record sets?

This is what I tried...

in detail I put:

orecordset.fields("mainkey").value

In detail band on entry I put:
orecordset.movenext

Seemed to work but you need a table open. (perhaps I have to create a dummy table and insert the number of records in the recordset?)


Is this a good way to do it or is there another better way.

I suppose I could use the rstocursor.prg or whatever it's called to convert the recordset to a cursor but I have found this a little slow...

I also know I can put all the values in an array with
myarray=orecordset.getrows()

But then I'm back to the same problem.

The problem is I have fifty million reports out there I need to convert.

Thanks for your suggestions.