I was creating a report as an Admin using the Data tab in the Report>Query window but now when I open Report>Query, the SQL tab is the first tab. I no longer have a Data tab and can no longer modify the report. I must have selected the Profile tab, clicked the SQL Radio Button, clicked Edit...
Saving the report as an IQD file did the trick. At this time all I needed was to view the SQL. I will keep in mind the issue with local-only functions if I need to edit the SQL. Thanks for the help!
HJ
I am trying to view the SQL for an Impromptu report. I am in the SQL Query window, on the Profile tab. I have clicked the SQL radio button and the Edit button. I receive the message "Cannot Edit SQL. This report cannot be translated to a single database-only query". I have also tried the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.