SAP Knowledge Base Article - Public

1771811 - Crystal Reports generates invalid SOQL for complicated Record Selection formula

Symptom

  • Error: "Database Connector Error."
  • In Crystal Reports, when refreshing a report based off a Saleforce.com data source, it fails with the error: "Database Connector Error."
  • Other reports based off Salesforce.com refresh successfully in Crystal Reports.
      
        
  • 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.

Environment

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

Reproducing the Issue

  1. In Crystal Reports, create a report off Saleforce.com.
  2. Add a complex Record Selection formula like:
        
       ({Case.LastModifiedDate} in YearToDate and {Case.CreatedDate} < Date (2011, 10, 01)) OR {Case.ClosedDate} in YearToDate
          
  3. Refresh the report
  4. Notice a Database Connector Error.
  5. Check the SOQL by clicking Database | Show SQL Query... and notice it is missing parenthesis.

Cause

  • The issue has been identified and logged under Problem Report ID ADAPT01657927

Resolution

  • The issue is resolved in the following product updates:
        
    • Crystal Reports 2008:
      • Fix Pack 4.4
      • Fix Pack 5.4
      • Service Pack 6
               
    • Crystal Reports 2011:
      • Support Pack 04 - Patch 4
      • Support Pack 06

See Also

Keywords

  • SFDC
  • ADAPT01658149
  • ADAPT01657928
, KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011