Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changed datasource location but query is still using the old one 1

Status
Not open for further replies.

chrisgeek

Technical User
Oct 16, 2008
25
US
SQL 2000 with Crystal 10. The report consists of two views that are inner joined. The databases are a production and a test which are mirror images. The only difference is the db name. I am attempting to change the data source on a report but it's giving me an error with a description of invalid object name with the original db as the object. When I check the query the original db name is there. How do I change this? The first time I changed it it was no problem just using the set datasource location but now it's not working. Thanks in advance for any help you can provide.
 
In Set Datasource

Click on each table and open properties.
Double click overridden Qualified table name and enter the table/view name as shown in the table name above.

This will remove schema name.

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top