cancel
Showing results for 
Search instead for 
Did you mean: 

set table location

Former Member
0 Kudos
38

Post Author: midav

CA Forum: Data Connectivity and SQL

Hi, CR 8.5 had a menu option where one could manually modify table location from [db_name].[owner].table_name to just table_name by deleting [db_name].[owner] prefix which would make your report portable between different databases. It seems Crystal 11.5 doesn't have this option any more.How can I achieve the same in CR 11.5 designer?Thank you, Midav

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: zen69

CA Forum: Data Connectivity and SQL

Are you sure you can delete it or it was creating an alias for the table? eg: SELECT * FROM [dbname].[owner].table MyTable Then you can use MyTable.field ? Maybe you should use ODBC to connect to the DB ?