Symptom
- Report refreshed without entering value for mandatory parameter(s).
- It is possible to leave mandaroy string parameter blank in Crystal Reports, and the report will still sucessfully refresh.
- How to ensure user enter a values for mandatory parameters in Crystal Reports?
Environment
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
Reproducing the Issue
- In Crystal Reports, create a report off any data source.
- Create a parameter, and set the data type to: String.
- Set the parameter option: "Optional" to False. ( This will make the parameter mandatory )
- Add the parameter to the report.
- 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 string, but not for any other data types.
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 Business View Manager , Problem
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016