CR 8.5 - Show SQL Query... is disabled

[cpaynter]

I've got a problem - I need to modify the SQL query for my report, and no matter what I do, the "Show SQL Query..." option on the Database menu is disabled. Am I missing something?

Chris.

 

[JEX]

What is your datasource? Are you, for example, using multiple datasources in the one report? You will not see it then.

J

 

[cpaynter]

No, just one Access database. First I tried it linking directly to the Access database. Then something made me wonder if this feature was limited to ODBC sources, so I attached to the Access mdb via ODBC. Still no luck.

Chris.

 

[dgillz]

This feature is only available to ODBC data sources.

I just tessted this with Access and this option is available to me. I am using Crystal v8.5 developer edition.

What version of Crystal are you using, and what edition? Perhaps this is not available in standard or professional editions.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[cpaynter]

Thanks for your response. I'm using

CR Developer; Product Type: Full
Product 8.5.0.217 CRW32 8.5.0.217

It's good to know that I should only expect this to work with ODBC datasources. Here's what I'm doing.

File | New
Select "As a Blank Report" and click OK
Open up ODBC, find MS Access 97 Database
Navigate to and select my .MDB
Double-click a couple of tables to select them, click Close
I'm now in the Visual Linking Expert, where Crystal has linked my tables automagically
I click OK, then Close
I'm now in the report designer, so I click on Database and...
Show SQL query is disabled

Am I nuts?

Chris.

 

[rhinok]

FYI, this also happens when you open a report from an Enterprise Folder. If you're doing this, you need to copy the report in order to view the SQL.

 

[dgillz]

Chris,

Set up an ODBC datasource in control panel which points to your .mdb, and connect to the ODBC datasource in crystal, and try it again.



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[cpaynter]

OK, I just tried that. I created User DSN to point to my MDB, went back into Crystal and selected that as the data source...same results. Show SQL Query is still disabled.

Sigh.........

Chris.

 

[dgillz]

You must actually place an object from your database on the report before this becomes available.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[cpaynter]

(Sound of hand hitting forehead)
Thank you, thank you, thank you!

Chris.

 

[JEX]

Hi,

FYI - in v9, showing SQL query is not restricted to ODBC connections only.

In addition, may I suggest you use a system DSN instead of a User DSN - if you ever create 2 with the same name you will encounter conflicts.

cheers, J