I'm currently developing a project that uses sql2000 as its database but access2003 as a front end application. The forms are getting the data via an ado recordset and are all working very well. Now i want to generate some reports based off of this data.

The reports, much like the forms, are unbound. I know that in a bound access form i can use:

report.recordset = "SELECT customerid, customername, customeraddress FROM customers"

This, of course, wont work as the tables are not being kept in access. It's my understanding that I can use the ado shape command to accomplish this. However, I'm having a very hard time finding information on not only how it works but more specifically how to use it to place data into an access report.

I've been readding the concept article at Microsoft on shape, but it doesn't go into any detail on how to use it.

Any help would be appreciated.