Joined: 14 Jan 2010
Location: United States
Online Status: Offline
Posts: 2
Topic: Show SQL Query not working Posted: 14 Jan 2010 at 6:33am
I'm running Crystal XI and when I develop reports, under the Database, Show SQL Query option the dialog box simply displays the table names but none of the rest of the SQL code - not even the FROM with the table names?????????
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 14 Jan 2010 at 1:18pm
Are you in the r2 version of Crystal XI? Have you applied any service packs? What type of database are you connecting to and what type of connection are you using (native, ODBC, OleDB, etc.)
Joined: 14 Jan 2010
Location: United States
Online Status: Offline
Posts: 2
Posted: 15 Jan 2010 at 4:31am
After exploring this further, it looks like it's not Crystal but the OLE DB connectivity driver provided by the database software vendor. Even the Add Command feature doesn't allow anything but opening the vendor's code generator software. I think the only way I'm going to solve this is to get access to the ODBC connection. Thanks.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
