Set Location without being in the designer

Posted on 2004-11-05
Last Modified: 2008-02-01
When a database location changes, but the database table and field names stay the same it's possible to use the Set Location in Crystal reports to remap from the old database to the new one. Is it possible however to change this without doing it through the Crystal Reports Designer? Also I'm not actually displaying the report in a custom application, it's a 3rd party app that displays them. Is there some way to pass a parameter or something? Thanks
Question by:TerraKeith
    LVL 100

    Expert Comment

    It is possible to do this from an application but the application has to be written with this in mind.  Your thir party tool may be able to do this for you.

    LVL 10

    Accepted Solution

    there are two ways according to what you have.

    if you have crystal reports then you can go to set location
    2. Create new connection
    3. Select the new db and corresponding table
    4. Click the old table
    5. Click Update
    This is the easiest way.
    Or you can do all this dynamically by writing a small application. If you go to this route then you have to decide the language that app will be written, version for crystal, object model that should be used for crystal These have to be answered before you start your app.


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…

    754 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

    21 Experts available now in Live!

    Get 1:1 Help Now