cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to View SQL query

Former Member
0 Kudos

Hi, I was trying to view the SQL of a crystal report connected to Oracle11 DB via native connection. But the "show SQL option " under database menu is greyed out. can someone please let me know the reasons behind this greying out of the option . Is there any way I can view the query of this report??

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

What is the data source for the report, tables, views, stored procedure.

If source is a stored Procedure I think the Show SQl is greyed out.

Ian

Former Member
0 Kudos

Thank You for the quick response. The report is created on a single table . This table's fields are placed in the subreport which is placed at the footer section of the Main report. The main report just holds the column header. I hope its clear.

Former Member
0 Kudos

Then you need to be in SubReport design screen.

You can access SR SQL from there.

Ian

Former Member
0 Kudos

Yeah ..Got it..Thanks a lot!!

Answers (0)