SAP Knowledge Base Article - Public

1294496 - How to create a report off a Salesforce.com report in Crystal Reports?

Symptom

  • How to report off a Salesforce.com report?
  • How to create a report off a Salesforce.com report in Crystal Reports?

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Resolution

  • In Salesforce.com, it is possible to view the information stored in the tables by creating Salesforce.com report.
  • Salesforce.com reports are seen in external applications, like Crystal Reports, as a Stored Procedures.
  • To create a report off a Salesforce.com Stored Procedure in Crystal Reports, follow the steps below:
         
    1. In Crystal Reports, under the menu "File", select "New - Blank Report"
    2. In the "Database Expert", under "Available Data Sources:" double click on "Salesforce.com"
         
       SForce - SP - 01.png
                 
          
    3. In the "Salesforce.com" window, enter the Salesforce.com user credential, and click "Finish"
         
       SForce - SP - 03.png  
             
          
    4. Expand the Salesforce.com connection, and under "Stored Procedures", select the Salesforce.com report, and add it to the report.
         
       SForce - SP - 04.png  
             
    5. Click "OK"
    6. In the "Design" view of the report, add the desired database fields.

Keywords

CRDC, stored procedure, salesforce.com, SFDC, crystal reports, salesforce.com database driver, CR , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

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