SAP Knowledge Base Article - Public

1294032 - What are the Salesforce.com objects that can be used when connecting to Salesforce.com from Crystal Reports?

Symptom

  • Can we report off a Salesforce.com report?
  • Can we report off our own Saleforce Query (SOQL) in Crystal Reports?
  • Can we report off a custom Salesforce.com table in Crystal Reports?
  • What are all the Salesforce.com objects that can be used in Crystal Reports when reporting off Salesforce.com?

Environment

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

Resolution

  • Crystal Reports can report off all of the following Salesforce.com objects:
    • Tables
    • Salesforce Query (SOQL)
    • Salesforce report
            
          
  • Tables
    Salesforce Objects are exposed as tables in Crystal Reports. You can add any Standard Salesforce tables and Salesforce Custom Table and fields to your report.
            
         
  • Salesforce Query (SOQL)
    It is possible to write your own Salesforce Query in Crystal Reports by using a Command object.
        
    For information on how to create a report off a Salesforce Query in Crystal Reports, see the following SAP Knowldge Base Article:
    1294510 - How to create a report off Salesforce.com in Crystal Reports using your own SOQL query?
       
       
  • Salesforce report
    Salesforce reports can be created, modified and viewed through the Reports tab on the Salesforce.com website.
    Salesforce.com reports are exposed as stored procedures in external application like Crystal Reports.
    With Salesforce.com stored procedures, you can leverage your existing Salesforce Reports.

    For information on how to create a report off a Salesforce Reports in Crystal Reports, see the following SAP Knowldge Base Article:
    1294496 - How to create a report off a Salesforce.com report in Crystal Reports?

Keywords

Sforce, CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016