Have to change odbc data source

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Cliff_Wiernik
Posts: 142
Joined: Tue Oct 10, 2017 12:44 pm

Have to change odbc data source

Post by Cliff_Wiernik » Sat Sep 08, 2007 10:25 am

I was developing my first sql report using a local version of my data with a different data source name. How can I change the master table and joins to use the actual live data source without redoing the entire report.____Cliff

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Have to change odbc data source

Post by kfleming » Tue Sep 11, 2007 8:01 am

You change the data source when you open the report using the File Open dialog.____There is a choice at the bottom of the dialog to select the data source.____Kathleen__R&R Support

Cliff_Wiernik
Posts: 142
Joined: Tue Oct 10, 2017 12:44 pm

==> Have to change odbc data source

Post by Cliff_Wiernik » Tue Sep 11, 2007 5:21 pm

Thanks. I did not see that. I was adding the new data source but was not getting the datasource to change so I could disconnect/delete the original data source.____This works as intended.

Post Reply