1892221 - "Set to Null" Checkbox missing for the parameter in Crystal Reports

• Parameter option, "Set To Null" is missing.
• For the same parameter, the checkbox is available in a different report.
• Set to Null checkbox is missing for some parameters in Crystal Reports.

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020

1. Create a report using a Stored Procedure as a datasource in Crystal Reports.
2. This Stored Procedure should have more than one parameter defined in it.
3. Edit one of the parameter on report level and make it dynamic using the existing list of value(lov) from the Business View Manager.
4. Now when one would refresh the report the checkbox goes missing.
5. Now edit the parameter once again and select a different list of value.
6. Refresh the report and the checkbox is available.

• The "Set to null" check box option appears only for parameters created in a Stored Procedure, or report based off an SAP BW BEx Query. ( It will not appear for report based off Tables, Views,... )
     
• Note that even if a parameter is created in a Stored Procedure, the option: "Set to null" will not appear when the Stored Procedure parameter is edited in Crystal Reports, and pointed to a List of Values (LOV), which is not based off a Stored Procedure.

• In Crystal Reports, do not change the Stored Procedure parameter to point to a List of Values (LOV)

prompt, lov, checkbox, set to null, database, bvm , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

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