Is it possible to use plain SQL in the Recordselection Fromula?
E. g. instead of
{table.field} = .....
to use standard query strings like
table.field = .....
Werner
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
To explain peter57r's point a little more - when you connect to the database under Database Expert there is an option called "Add Command" just on top of the server name. Double click that and a window will open. Enter you SQL query there and the resulting data set will be your table wich you then use to build your report.
Here is some more information on the same: http://publib.boulder.ibm.
Hope this helps.
P.
Crystal uses { } to specify the field is a database field, formula, running total, or parameter rther than a variable. So the { } are required when you use the SELECT EXPERT to specify the filter.
You can try to change the reports to use a COMMAND.
Why do you want it to use "standard" SQL syntax?
mlmcc
I use Crystal over RDC and com. Usually all the queries are already in my app as plain SQLs. Translating them to the weird Crystal syntax is tricky and tedious. E.g. I never understood, why they have other expressions for the in clause.
In principle I need a parser.
So, as You suggested, it is better to go over a Command. Using them over com is also tricky. But it should work.
Second I am glad to know now, that there is no hidden switch to switch on SQL selections. SQL fields are no solution, because using them You switch off the optimizer of the SQL engine.
Thank You all
Werner
Business Accounts
Answer for Membership
by: peter57rPosted on 2009-07-05 at 04:52:05ID: 24779703
No.
You can base the whole report on a sql command, using the AddCommand option at the point where you would otherwise select the tables for your report.