Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Show SQL Query not working Post Reply Post New Topic
Author Message
gpalmer
Newbie
Newbie


Joined: 14 Jan 2010
Location: United States
Online Status: Offline
Posts: 2
Quote gpalmer Replybullet 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?????????
gpalmer
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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.)

-Dell
IP IP Logged
gpalmer
Newbie
Newbie


Joined: 14 Jan 2010
Location: United States
Online Status: Offline
Posts: 2
Quote gpalmer Replybullet 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.
gpalmer
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.015 seconds.