Kbase P110479: Crystal Reports causes error 10713 when running report which invokes the USER() function
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/08/2009 |
|
Status: Verified
SYMPTOM(s):
Crystal Reports causes error 10713 when running report
Report uses SQL function {fn USER()} in the report
Error in compiling SQL Expression:
Query Engine Error:
HY000:[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax error in SQL statement at or about "}" (10713)
[Database Vendor Code:] -210056]
Same error occurs trying to create an Expression field in the Crystal Reports Expression Editor
OpenEdge 10.0B03
FACT(s) (Environment):
OpenEdge 10.0B
Windows
OpenEdge 10.1C
CAUSE:
Crystal Reports is generating an invalid SQL statement. The SQL statement being generated is 'SELECT {fn USER()}' which will not work in against any SQL database.
The error occurs when the wrong Crystal Syntax is used to create an Expression field in the Crystal Reports Expression Editor
FIX:
Contact Crystal Reports concerning this issue as it involves how Crystal itself is generating the SQL which it sends to the ODBC driver or use the correct Crystal syntax to create the field.