...having a little problem using Crystal Reports and UV-ODBC on Universe 10.1.
One of our developers created a simple report using Crystal Reports and the SQL generated by Crystal Reports doesn't work on Universe. After looking at the SQL statement generated by Crystal Reports, we noticed the alias name table was identical to the name of table name. I'm supposing this is ambiguous to UV-ODBC query processor and is therefore illegal. Crystal generates the alias on its own using just table name, but seems to get the table name from UV-ODBC. There may be an easy way get Crystal to use a different alias naming convention (we're just learning Crystal)... But, I was wondering if anyone knows of a way in UV-ODBC, UCI, etc. to have a "full table name" (i.e. "schema.tablename") returned to the client query engine? Note, the tables are not defined in a Universe SQL schema. Tom Firl Database Analyst Columbia Ultimate 4400 NE 77th Avenue, Suite 100 Vancouver, WA 98662 Phone: 360-256-7358 x137 Fax: 360-260-1614 [EMAIL PROTECTED] ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
