Crystal Reports XI SQL Expression error: ORA-00936
Posted on 2007-07-24
I am currently experiencing problems making a very basic SQL Expression in Crystal Reports XI. Here is the query:
FROM "DEV"."PATIENT" PATIENT
Here is the error I get:
Error in compiling SQL Expression:
Failed to retrieve data from the database.
Details: ORA-00936: missing expression
[Database Vendor code: 936 ].
The frustrating part is that I did not write this SQL Expression myself. After trying everything I could think of while writing my own queries, I did the following: I created a new report, selected only the table I want to pull a field from. Dragged the field onto the Details portion of the Report on the Design screen. Went to Database > Show Sql Query ... on the menu. Copied the SQL query. Deleted the field from the report. Created an SQL Expression and pasted in the query.
I'm sure there's something I'm missing but I'm all out of ideas.
We're running an Oracle 9 database