SAP Knowledge Base Article - Public

2310417 - Unable to check the Set Null option on Sybase Stored Procedure Parameter in Crystal Reports

Symptom

  • Unable to check the option "Set To Null"
  • In the Parameter Prompt window, unable to set Null for the parameter in Crystal Reports, when reporting of a Sybase ASE Stored Procedure.

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
       
  • SAP Sybase ASE

  • ODBC Connection using the  Adaptive Server Enterprise & CR Sybase Wire Protocol ODBC driver.

Reproducing the Issue

  • In Crystal Reports 2008
    1. Create an ODBC connection over Sybase ASE using Adaptive Server Enterprise Driver.
    2. In Crystal Reports 2008, create a report over Sybase ASE based stored procedure.
    3. Note: Parameter has to be declared on the stored procedure SQL.
    4. Refresh the report and in the prompt window "Set Null" check box was enable for the respective parameter.
    5. Check "Set Null", and report works fine.
  • In Crystal Reports 2011 and above
    1. Create an ODBC connection over Sybase ASE, using CR Sybase Wire Protocol ODBC Driver.
    2. In SAP Crystal Reports 2013, create a report as per the steps given above, "Set Null" was observed grayed out

Cause

  • ODBC connection created using CR Sybase Wire Protocol ODBC driver over SAP Sybase ASE, do not have option to set “ANSI NULL” OFF or ON under configuration windows.

  • Crystal Reports Native Driver uses SET statements to change ANSI Null to OFF.
    • SET ANSINULL OFF
    • SET QUOTED_IDENTIFIER OFF
  • Sybase ODBC Driver has a setting for this so it is not change automatically by Crystal Reports.

Resolution

  • Use Adaptive Server Enterprise driver for ODBC connection and in configuration window, under the tab  "Connection", check the option: "Set ANSI Null"

See Also

1616849 - Sybase values repeating in CR using ODBC DSN

Keywords

Set Null Sybase, Sybase stored procedure, unable to set null, Sybase ASE ODBC , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

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

Attachments

SYBASE ODBC.jpg
Sybase ASE configuration.jpg