SAP Knowledge Base Article - Public

1473287 - Error: 'the value is not valid' when a null value is entered in the parameter dialog box in Crystal Reports

Symptom

  • Cannot use null values in the 'Enter Parameter Values' dialog box
  • Error: 'The value is not valid'

Environment

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

Reproducing the Issue

  • Create report with either static or dynamic parameter
  • Refresh the report
  • Assign no value to the parameter in the 'Enter Parameter Values' dialog box
  • Select 'OK'

Cause

The parameter requires a value

Resolution

  • Edit the existing parameter
  • Set Optional Prompt as True in the 'Value Options' window
  • Create a record selection formula using the 'Hasvalue ()' function

For further information on the use of 'Hasvalue ()' function, please refer to CR user guide 

Please note that the optional parameters have been implemented since version 2008

Keywords

list of values, entry, empty, '...' , LOV , KBA , crystal reports , prompt , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016