sql statment integration into functions

[Hambone2]

I'm new to CR but am an ASP developer. I'm using CR 8.5 and I want to know if it is possible to use sql statments in the formula fields editor WITH the basic syntax. If so, how?

The documentation that I have hints at it but does not go any further.

 

[MalcolmW]

I'm not clear what you want to write - SQL in BASIC, in a Crystal Reports formula?
The SQL Expression Editor allows some SQL like coding to develop expressions. The Record Selection Formula can be written in BASIC, and Crystal translates that into the SQL WHERE clause. What were you thinking of? Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[kenhamady]

Keep in mind that the SQL expression editor does not allow writing a SQL 'statement' just a SQL expression to generate a new column in the results. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[MalcolmW]

Yeah, and it's not even in SQL, but a Crystal derivative that has just a few simple SQL like functions in it. However, it sounds good in the sales literature. (Yes, I disgruntled when I first actually tried to use this feature ;-))
Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net