BIP - Parameters

Equal

If you use a parameter in your report, don't forget to use the NVL function in your predicate clause such as:

and e.employee_id = nvl(:emp,e.employee_id)

IN

An in predicate parameters passing a NULL value for no selection.

Configuration:

SQL:

select division from divisions where 
(
   division in (:DivisionName)
   or (coalesce(null, :DivisionName) is null) 
)