BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports - How-To's

How to change the data source of a report

Changing the data source location in Crystal Reports s required if someone sends you a report that uses a database that has a different location than your system, or if you have changed the directory or disk location of the data source (database)

To change an existing report to connect to the database if the database has been moved to a new location or if the database has been renamed, use the ‘Set Location’ command.

1. From the tool bar, click on Database, choose Set Datasource Location.

2. Once the Set Location dialog box appears, highlight/click on the database or table in the Current Data Source window (top half)  that you want to replace.

3. Highlight the database or table in the Replace with window  (bottom half) that you want to use.

4. Click Update.

5. Once complete, click close.

Tagged , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>



Use the Chart Sort Order dialog box to sort and group your chart data. This dialog box appears when you click the Order button on the Data tab of the Chart Expert for a chart with the Advanced layout type.