SAP Knowledge Base Article - Public

1205754 - Error in compiling SQL Expression when using SQL Expression Fields

Symptom

While using SQL statements in SQL Expression Fields, an error message " Error in Compiling SQL Expressions" occurs.

Cause

NA

Resolution

1. Enclose the entire SQL Statement within a single paranthesis as given below

(select sum(`Account`.`accid`) from Account where `Account`.`name`='Asha'
group by `Account`.`name`)

2. Now this will work fine.

Keywords

sql expression, sql statements , 8633030 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2