Is there a way to view the sql that will be executed without actually running the report.

I have a report that is not responding, so the methods I got from searching the forum seem to only work with successful running of the report.

Thanks,
Frankie

When You say not responding...are you getting an error message? Or just nothing happening.
You can try adding in the beginning.
-SET &ECHO=ALL;

And you should get back what Focus Code is doing.

See below. I have had success with this but sometimes it doesn't work. I'm not sure why. The "SET XRETRIEVAL=OFF" causes the code not to execute. Try it for yourself:

SET TRACEOFF = ALL
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = SQLAGGR//CLIENT
SET TRACEUSER = CLIENT
SET XRETRIEVAL=OFF
-RUN
<----- PUT FOCUS CODE HERE ------>