1751918 - Mandatory parameter is not enforced in Crystal Reports

SAP Knowledge Base Article - Public

1751918 - Mandatory parameter is not enforced in Crystal Reports

Symptom

  • Report refreshed without entering value for non-optional (mandatory) parameter. 
  • It is possible to leave mandaroy string parameter blank in Crystal Reports, and the report will still sucessfully refresh.

Environment

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

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Create a parameter, and set the data type to: String.
  3. Set the parameter option: "Optional" to False.  ( This will make the parameter mandatory )
  4. Add the parameter to the report.
  5. When refreshing the report, it prompt for the parameter. If no value is entered for the parameter, it still refresh the report,
    when the expectation is a value is required for the parameter, before the report can be refreshed.

Cause

  • It is not required to enter any values for string parameter, as blank is an acceptable value for parameter of data type, but not for any other data type.

Resolution

  • To make it mandatory to enter a value for a  String Parameter in Crystal Reports, do one of the following:
      
    • Edit the parameter and set the Mask option to: "Aaaaaaaaaaaaaaaaaaaaaaaa"
      (Add as many "a" as the maximum length for the parameter); OR
           
    • Set the parameter option:Minimum Length to 1 character.

Keywords

CR, Mandatory, required entry , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013