SAP Knowledge Base Article - Public

2247113 - Crystal Reports 2013 crash when refreshing a report based off a custom Salesforce Query ( SOQL )

Symptom

  • Crystal Reports crash when refreshing a report based on Salesforce.com Command Object.
  • Crystal Reports 2013 crash, when attempting to refresh a report based off Salesforce Query (SOQL)
  • In Crystal Reports 2011 and below, the same report refresh successfully.

Environment

  • SAP Crystal Reports 2013
        
  • Salesforce.com

Reproducing the Issue

  1. In Crystal Reports 2013, create a new report off Salesforce.com data source.
  2. Add a Command Object, and type a Salesforce Query (SOQL)
  3. Add database fields to the Details section of the report.
  4. When refreshing the report, Crystal Reports 2013 crash.

Cause

  • The issue occurs due to the Salesforce Query (SOQL) contains more than one database fields with multiple levels of child-to-parent relationships, like:
       
    SELECT Name, MyCountryLink__r.MyRegionLink__r.MyCityLink__r.MyAddressLink__r.Name, 
    MyCountryLink__r.MyRegionLink__r.MyCityLink__r.Name, MyCountryLink__r.MyRegionLink__r.Name
    FROM MyCustomer__c
         
  • This issue has been reproduced at SAP, and tracked under SAP Note 2028040

Resolution

  • The issue is resolved in the following product updates:
                
    • Crystal Reports 2013:
      • Support Pack 03 - Patch 7
      • Support Pack 04 - Patch 5
      • Support Pack 05 - Patch 1
      • Support Pack 06 and above

Keywords

SFDC, SForce, CR, SOQL , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports 2013