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

Support for Crystal Reports within Jiwa.

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

Postby andremarion » Tue May 26, 2015 2:44 pm

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
andremarion
I'm new here
I'm new here
 
Posts: 2
Joined: Tue May 26, 2015 2:18 pm

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

Postby Scott.Pearce » Tue May 26, 2015 2:47 pm

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.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 743
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

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

Postby andremarion » Tue May 26, 2015 2:57 pm

That's unfortunate indeed.
Thanks for the prompt response.
andremarion
I'm new here
I'm new here
 
Posts: 2
Joined: Tue May 26, 2015 2:18 pm


Return to Crystal Reports

Who is online

Users browsing this forum: No registered users and 1 guest