[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

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.
  • 2
1 Solution
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...)

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now