2130829 - Boolean fields in Crystal Reports 2013 for salesforce.com stored procedure reports display as -1

SAP Knowledge Base Article - Public

2130829 - Boolean fields in Crystal Reports 2013 for salesforce.com stored procedure reports display as -1

Symptom

  • Boolean field display as -1
  • "-1" displayed instead of "True" for Salesforce.com Stored Procedure field of data type "Check Box", in Crystal Reports.
  • In Crystal Reports 2011 and below, the same report displayed the boolean value as true or false, and not as -1, or 0.

Environment

  • SAP Crystal Reports 2013 - Support Pack 05 Patch1 and higher
       
  • Salesforce.com

Reproducing the Issue

  1. In Crystal Reports 2013, open an existing report with "Check Box" field of salesforce.com stored procedure.
  2. Refresh the report.
      
    Notice the Boolean fields are displayed as -1, or 0, instead of True or False.

Cause

  • With the new salesforce.com driver in Crystal Reports 2013 the "Check box" fields values displayed as real Boolean values, while in previous versions of Crystal Reports the fields displayed as String values "0" and "1".

Resolution

  1. Open the existing report in Crystal Reports 2013 SP05 Patch1
  2. Under the menu "Database", select "Set Datasource Location..."
  3. Click on the Stored procedure name in the top window to get it highlighted.
  4. Create a new connection to Salesforce.com, and find the same Stored Procedure, then highlight it.
  5. Click the Update button.
  6. It should Prompt with a mapping dialog.
  7. Remove the check from Match type box.
  8. Map the Boolean fields and click OK.
  9. Right-click the Field, select Format and select the format you need. ( True or False, Yes, or No, .... )

Keywords

SFDC, reports, check field, boxes, STProc , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2013