Hi!

Well,

orecordset.movenext is not enough. You require to move record back in the main (dummy) cursor. Otherwise, if eof() reached in that cursor, report finished.

If you have a lot of reports, to simplify changes make a function that you will call from report.

>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.