SQL Expression Editor not found in Formula workshop

[jcwnow]

I'm trying to write a sql expression in my Crystal report, but the sql expression editor does not exist in the Formula Workshop for my report.

I wrote a report a few weeks ago and in that report, the sql expression editor is there.

Both reports are written against the same Oracle odbc database.

I noticed what seems to cause the problem. The report I'm having problems with has existing command objects. The report that had no problems did not have a command object. I then added a command object and the sql expression editor then disappeared from the Formula Workshop.

I running Crystal 12.2.0.290 with an Oracle odbc connection.

 

[lbass]

You can't use SQL expressions if you are using a command. You should be building the expression directly into the command instead.

-LB

 

[jcwnow]

The command objects in this report aren't used to provide selection. They create virtual tables that supply extra data to the report. My primary selection is done through record selection in the formula workshop and that's where I'm trying to use the sql expression. I'm doing that so I push the selection work down to the server. I've tried to write the sql expression directly into the record selection but I keep getting syntax errors on basic stuff such as

"EMPLOYEE"."TERM_DATE" = TO_DATE('01/01/1700','MM/DD/YYYY')

I was hoping that if I wrote this TO_DATE expression in sql expression editor, I'd be able to use it in the record selection editor above withot getting the errors.

 

[lbass]

Why use a SQL expression for this? You should be able to use:

{EMPLOYEE.TERM_DATE} = date(1700,1,1)

This will pass to the server.

-LB