Symptom
- Getting the following error while running a DeskI report using "calculation" operand in a condition in the query panel- "Exception:DBD, [Microsoft][<Driver>]Syntax error in query expression'<Expression>'. State: 42000".
- Error appears in a situation when one object is coming from the main table and the other coming from its alias table.
Read more...
Environment
- BusinessObjects XI 3.1 SP5 Fixpack 5.1 (and higher fixpacks)
- BusinessObjects XI 3.1 SP6
- Desktop Intelligence
Product
SAP BusinessObjects Enterprise XI 3.1
Keywords
calculation, sub query, alias, DeskI, incorrect SQL , KBA , BI-RA-DKI , Obsolete - Desktop Intelligence , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.