Change Data Source of Crystal Report

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.
Who is Participating?
If you have Crystal reports as the actual product you can change the datasource location and provide mappings for your fields to fields in your new source. I'm not sure if the stripped version in VS2005 can do the same.
Then you'd just wished you have not based your report on a database, but on a XSD, which would have left you with just changing your connection string in your app :D
But you also might have a look at the connection properties of your report when you load it, it is possible to modify them after creating the object. (but make sure you go all the way through your report/subreports...)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.