Adding full table names 1

[Jyme]

I need to have the query select from dbname.dbo.client
instead of just client, in my query thats going to my sql server from crystal..is there a way to make it change to that format?

thanks

 

[vidru]

It depends on your version of Crystal.

For 8 and 8.5, the default for ODBC connections to SQL Server is "Database.dbo.TableName", while Native connections don't explicitly show the schema. You can change it from Database > Set Location.

Don't have CR 9 here, but I thought it always defaulted to the "Database.dbo.TableName" schema. You can check out the options from Database > Set Datsource Location.

-dave

 

[Jyme]

Yes I am using a Native Connection, not ODBC..can I do it with this or do I have to change it to an ODBC connection?