Change Data Source of Crystal Report

Posted on 2006-04-07
Last Modified: 2010-04-23
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.
Question by:AccessYourBiz_Com
    LVL 14

    Accepted 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
    LVL 14

    Expert Comment

    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

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Article by: jpaulino
    XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String ( Literal, only instead of starting and ending with w…
    Article by: Kraeven
    Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now