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 Business View Manager , Problem
Product
SAP Crystal Reports XI ; SAP Crystal Reports XI R2