SAP Knowledge Base Article - Public

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


  • Boolean field display as -1
  • "-1" displayed instead of "True" for 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.


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

Reproducing the Issue

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


  • With the new 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".


  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, 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, .... )


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


SAP Crystal Reports 2013