Skip to Content

Crystal Reports 14 - Set DataSource Location

Currently, we have a DataSource for Production and a DataSource for Test.

To change between the two, we do a 'set datasource location'. When we set to Production, I believe we are impacting Production database performance. Doing this does a validate of data between the different DataSources ?

Is there a better way to segregrate production vs test data connections ?

When we are building a report or making major modifications we want to be connected to test.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 03, 2017 at 11:01 AM

    What database are you using?

    If Oracle and tables names are same you can make report Schema independent by going to Set Datasource click and open up each table.

    Click on the line which says something about Alias do not have crystal open so can't recall exact title. Enter the table name into that field, repeat for each table. When you port to Production you will not need to verify each table.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 02, 2018 at 04:52 PM

    Does anyone have input on use of Datasources of test vs production in Crystal Reports using SQL Server ? see question above...

    Add comment
    10|10000 characters needed characters exceeded

    • Thank you Abhilash,

      your answer helps. Currently, we have one server where we do development and it also serves as the production server where the reports run. Thanks for your input, this solves my question.