Page 1 of 1

Formula tab does not show the report's SQL Query used

PostPosted: Tue May 26, 2015 2:44 pm
by andremarion
Hi, I am hoping you can assist with an issue I am having.
After running a report in Jiwa 6 (logged on as ADMIN), and selecting the Formula tab, I can see the SQL Query used for the report, and use it for debugging if necessary.
However, after running a report in Jiwa 7 (logged on as ADMIN), and selecting the Formula tab, the SQL Query used for the report is not displayed. Instead it shows "SQL Query Used (Cleansed). Not Implemented"
In both instances the reports use tables and/or views.
How can I get the SQL Query used for the report to display in the Formula tab?
Thanks,
Andre

Re: Formula tab does not show the report's SQL Query used  Topic is solved

PostPosted: Tue May 26, 2015 2:47 pm
by Scott.Pearce
Unfortunately, Crystal have removed the ability to see the end SQL query fired by the report. I suggest instead using SQL Profiler when running to report to capture the query used.

Re: Formula tab does not show the report's SQL Query used

PostPosted: Tue May 26, 2015 2:57 pm
by andremarion
That's unfortunate indeed.
Thanks for the prompt response.