How do I change the Database connection my report is using?
I am new to Crystal Reports for Eclipse. I have been writing this report to pull information from a test database. Now I want to use that report to grab database from my production database which has the exact same structure as the test database.
How do I make a report point to a different Connection name? I can't seem to find an option or property that allows me to bind a report to a database connection.
If you want to change datasource location from Eclipse without creating a web application, then please follow following steps :
For the explaining this stpes, I am taking one example where I need to change db connection from SQL to Oracle
1) In the Database----> connections, make sure that both the connections i.e SQL and Oracle are in connected mode.
2) Open your report.Say report is created with SQL connectivity
and now you want to change this to Oracle.
3)Select Crystal Reports tab in eclipse and click on set Datasource Location option.
4) Select Oracle connection,click on OK and click on preview option.
So if your Oracle connection is in runnuing state, it should now point to the Oracle server.