I am looking for a programmatic way to change the report data source and field data source for a report. I bought your book several years ago and have used it a lot but I don't see anything that quite gets me what I'm looking for here.

Here is the scenario. I have a report that is using direct SQL. To simplify the explanation, let's say that I am using Northwind and the data is coming from Customers and Orders tables. On the report are Customers.CustomerId, customers.companyName, Orders.OrderId and Orders.OrderDate.

I want to change the report data source to a stored procedure or a .NET dataset without having to rebuild the report. Again, for the sake of simplicity, we'll say that the new datasource is named CustomerOrders. So after the change, the report should have the CustomerOrders.CustomerId, CustomerOrders.companyName, CustomerOrders.OrderId and CustomerOrders.OrderDate as the fields.

Any help would be appreciated. If there is a way to do this via the user interface, that would be OK too.

I read this section of the book but it doesn't really do what I want. For example,  a report uses 5 tables and I re-map the fields to a dataset. The report still shows the 5 tables as the datasource. The dataset shows as the source instead of the database/ODBC connection, etc.

I want the various tables to go away, period.