Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How do I change the Database connection my report is using?

Hi

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.

Help!!?

thanks

Former Member
replied

Hello Michel,

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.

Thanks,

Chinmay

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question