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.
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 strongm 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
- Thread starter chrisgeek
- Start date
-
1
- #2
IanWaterman
Programmer
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
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
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question