Show SQL

[Former Member]

I am a new user of Crystal Reports 10. When I use the Database drop down menu and try to select "Show SQL", this option, as well as the "Select Distinct Records" option is grayed out, not accessible.

How do I gain access to these grayed out options?

[former_member292966]

Hi Barbara,

The Show SQL Query is greyed-out if the database you are connecting to is a PC based database like dBase, Btrieve or Access through a direct connection.

The only time you are able to access the query is if Crystal connects to a SQL database like SQL Server, Oracle, etc. or to a PC based database through ODBC.

In older versions that used Crystal Queries to query the database first would also disable the query but that's because the query was done in the Query first then the report was created from the Query.

Good luck,

Brian