1977803 - Error: "INVALID_QUERY_FILTER_OPERATOR", when refreshing a report based on Salesforce.com in Crystal Reports

Error: "Failed to retreive data from the database".
When reporting on Salesforce.com in Crystal Reports, and filtering the data on an ID Field, it fails with the following errors:

"SAP Crystal Reports: Failed to retrieve data from the database"

SAP Crystal Reports: Database Connector Error: ‘HY000:INVALID_QUERY_FILTER_OPERATOR:
Id, Name FROM Account WHERE (id = ‘1’)
Error at Row:1:Column:38
Invalid ID filed: ‘1’ [Database Vendor Code: 47]’ "
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.

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

CR, Salesforce.com, sforce , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Visit SAP Support Portal's SAP Notes and KBA Search.