SAP Knowledge Base Article - Preview

2387522 - Error: 'MALFORMED_QUERY: Bind variables only allowed in Apex code' when refreshing a report based off Salesforce.com in Crystal Reports

Symptom

  • Error: 'MALFORMED_QUERY'
  • SOQL query fails when adding a parameter.
  • When hard coding the value in the SOQL query instead of using the parameter, the report refresh successfully.
  • When connecting to Salesforce.com in Crystal Reports, and adding a SOQL query with a parameter, it fails with the error:
      
        'Database Connector Error: 'MALFORMED_QUERY: WHERE <value=value.
         ERROR at Row:x:Column:y
         Bind variables only allowed in Apex code'
      
      
        
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
           
  • Salesforce.com

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

CR, SForce , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

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.