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.
LVL 3
AccessYourBiz_ComAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PockyMasterCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PockyMasterCommented:
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...)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.