Hi team

I want to dynamically create an RS and then set the Crystal to look at it with "Database.SetDataSource myRS" (I'm Using the Crystal Reports Designer). But it doesn't work. It seems that Crystal is looking for a table rather than an RS. In DAO I could have created a table on the fly, but I can't see how to do that with ADO. Any bright ideas?