I created a Crystal Report report using Visual Studio .Net 2005. The report actually is based upon three sources, two tables and one SQL view. The report has been working fine. Recently a client of ours asked to change something on the report and now I have to change the data source of the report. What I would like to do is replace the two tables and one SQL view with a new SQL view. When I try to remove the original data sources it removes the fields from the report.
I then tried to add the new view to the report, which it allowed, but I could not change the fields data sources to use my new view.
How can I change the data source of the report without removing/adding fields to the report? I don't want to create the report again. I have two other reports that I have to do this and it would take too much time to create the reports again.