Multi-Value Parameter Functionality and Limitations

Yes, Blitz Report automatically supports the conversion to an `IN-clause` (or `NOT IN-clause`) when the user selects the ‘Multiple Values’ checkbox . This automated replacement works for restrictions using the ‘not equal’ operator (`!=` or “), as well as ‘equal’ and ‘like’ operators . During SQL execution, the restriction is replaced with the equivalent `IN-clause` that includes all selected values .

A critical requirement for the automatic IN-clause replacement to function is that the parameter SQL text must have the table column name on the left side of the comparison operator and the `:bind` variable on the right side . For example, `column_name = :bind_variable` works, but a structure like `:bind_variable = column_name` will not enable the multiple values functionality .

No, if you use complex operators such as `>= :bind_variable`, the automated IN-clause replacement is not possible, and consequently, the ‘Multiple Values’ checkbox will not be available for that parameter . This feature is restricted to equality and simple likeness comparisons for clean conversion to an `IN` clause .

The multiple values functionality is only available for parameters defined with the anchor styles `1=1` (or `n=n`) or `&lexical` . It is explicitly not supported for parameters defined using the simple `:bind` anchor style .