on 2007 May 14 9:05 PM
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
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.