changing databases in odbc doesnt change database in report
In Sql Server, every table saved in
Crystal Report is denoted with
DatabaseName.OwnerName.TableName.
So, changing the database in ODBC will not change the tables location in
crystal report.
If you were using Access Database, then you could achieve your goal without
having to set the location again and again.
Best Regards,
Luqman
Quote:
> I have a vb program using crystl32.ocx. All reports are setup using an
odbc
> connection to sql server 7. I want to be able to change the database that
> the reports are pointing to at run time (both databases have the same
> structure and are on the same server).
> Just changing the database in the odbc doesnt work, unless each report is
> reset using Set Location.
> Any suggestions?
> Thanks
> Ann
