- Into the Report, identify the values in the column from which certain rows are required to be displayed
- Create a new Calculated Field.
- Type a Calculated Field Name.
- Set Formula Type as Simple and the Resulting Field Type as Text
- Configure the desired values to filter on the empty box as follows:
Example: CASE WHEN Status = 'Closed' THEN 'Null' ELSE 'NotNull' END
 6. Click the Save button instead of the Validate button because the Validate has a defect when using it and may detect the CASE statement with a syntax problem. 7. Back on the report, drag the calculated field created and the column to filtering to the Filter box
 8.Clic on Advanced Settings 9.Set the column as Equal to, and the Calculated Field as In List, then close the Configure Filters
 8.Move to Design 9.On the Filter menu on the left, select the value to be displayed, and click on Summit
|