Implementing Multi-Value Selection for Report Parameters

Blitz Report parameters are highly flexible. You can define a custom list of values (LOV) by setting the LOV type to ‘custom’ when creating the parameter. The underlying SQL of your report must be written to handle the list of values passed by the parameter, typically using an Oracle `IN` clause.

Key users can significantly simplify parameter creation by leveraging existing definitions. You can choose from any existing parameters already used by standard Oracle Concurrent Programs or the seeded Enginatics Blitz Reports. This saves effort on defining standard LOV validation logic.

When creating a new report based on an existing one, like copying a seeded report (e.g., Order Header and Lines to create a DIFOT report), the parameters are retained or can be redefined in the new copy, maintaining change control wherever applicable.