We have an OTBI report with a prompted calendar filter. The "operator" for this prompt is greater than, so rows will be included where the date is greater than what the user enters. We need it also to return rows where this field is null. The criteria for the report includes the filter conditions below, which we thought would account for both possible values. But when the user chooses a date in the prompt, those rows are returned, but the rows where that field is null are not being returned. Is there a better way to code for this? Thank you
We have the Criteria grouped as below:
AND XYZ date field is prompted
OR XYZ date field is NULL
