Symptom
Cannot retrieve only null values.
Environment
Crystal Reports (CR) 2008 only.
Reproducing the Issue
- Create report with a parameter.
- Refresh the report.
- Assign no value to the parameter in the 'Enter Parameter Values' dialog box.
- Select 'OK'.
Resolution
- Open the Report menu in CR.
- Select 'Selection Formula'.
- Choose 'Record'.
- Type the following record selection formula:
IF (not HasValue({?Optional_Parameter})) THEN IsNull({Field_with_NullValues}) ELSE {?Optional_Parameter}={Field_with_NullValues}
See Also
Knowledge Base article 1473287 - Error: 'the value is not valid' when a null value is entered in the parameter dialog box in Crystal Reports
Keywords
list of values, entry, empty, '...' , LOV , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
Crystal Reports 2008 V0 ; Crystal Reports 2008 V1