Cristal Report

[Former Member]

Hello..

I made a report of sales in Crystal Report, the problem is with this report I coudn't change of DataBase.

How can I change the Database?

thanks..

[Former Member · Accepted solution]

Click Database - Set Datasource Location.

Find the correct datasource and update the top with the bottom.

[Former Member · Accepted solution]

Hello

I don't see Set DataSource Location. I search it but I don't saw it

[Former Member · Accepted solution]

in Field Explorer, right click on database fields and select Set Datasource Location

[Former Member · Accepted solution]

the report don't change the DataBase, I have Crystal Report 2008

[former_member292966 · Accepted solution]

Hi,

What database are you connecting to? The steps will vary on the type of database.

Generally, go to Database | Set Datasource Location on the menu bar.

In the Current Data Source box click on the table you want to change.

In the Replace With box, log onto the new database and find the new table.

Highlight the new table in the Replace With box.

Press the Update button.

In the Field Explorer box you will still see the name of the original table. To make sure the report is pointing to the new table, go to Database | Set Datasource Location.

In the Current Data Sources box click the beside the table.

Click the beside Properties.

You can see the Table Name here.

If you are using a SQL database, you can also see the table in the query when you go to Database | Show SQL Query.

Good luck,

Brian