Jiwa

The Jiwa community forums

Skip to content

Sql query in Crystal2013  Topic is solved

Support for Crystal Reports within Jiwa.
Post a reply

Sql query in Crystal2013

Postby 2can2 » Fri Jun 05, 2015 11:34 am

Hi, In Crystal V6 reports you could run a report and then go to the formula tab and copy and paste the last line Query into Sql and run the select query to check your results.

Crystal 2013 doesn't allow this, is there a way to get the select statement? so you can test for results.

Cheers Doug
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25
Top

Re: Sql query in Crystal2013  Topic is solved

Postby Scott.Pearce » Fri Jun 05, 2015 11:50 am

See:
http://forums.jiwa.com.au/viewtopic.php?f=24&t=338
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
Top

Re: Sql query in Crystal2013

Postby 2can2 » Tue Jun 09, 2015 12:53 pm

Thanks Scot. Sorry I missed the previous query! :oops:
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25
Top
Post a reply

Return to Crystal Reports

Who is online

Users browsing this forum: No registered users and 5 guests

Powered by phpBB® Forum Software © phpBB Group
cron