Searching Parameters
Applies to: Kyvos Reporting
When users manually enter parameter values in a text box at runtime, they may inadvertently enter values that do not exist in the database. To avoid this, especially when the list of valid values is known or limited, using Dropdown or Option input types is recommended.
However, when there are many values to choose from, multi-selection using dropdowns or options can be inefficient. In such cases, Search provides a practical alternative, enabling users to search and select values dynamically using custom filters at runtime.
Prerequisites
Search is available only when:
The Input Type is set to Dropdown or Option.
The Dropdown Source is set to Dynamic.
Types of Search
Quick Search
Quick Search allows users to type the first few characters of a value to quickly retrieve matches.
To configure Quick Search:
On the Search tab, select Quick Search.
Specify a Default Value that should appear when the report is run.
Set the Min. Key Length. The search will start once the user types at least this many characters.
Note
Quick Search is available for Char data types only.
Advanced Search
Advanced Search is ideal for large datasets. It allows users to define complex filtering conditions to retrieve relevant records.
To configure Advanced Search:
On the Search tab, select Advanced Search.
Under Column Name, select a field from the result set of the dynamic query. Its Data Type will be auto-filled (you can change it, if needed).
Enter the Prompt—this is the label that appears at runtime on the Input Parameter Form (IPF). (This field is mandatory.)
Select an Operator (e.g., Equals, Between, Starts With) based on the data type.
Provide Value1 and Value2 (if the condition requires two values).
Note
Use the Add button to define multiple filter conditions. Click Remove to delete any condition.
Runtime Behavior
When the report runs:
The Input Parameter Form (IPF) will display a search icon next to the configured parameter.
Click the icon to open the Search Values dialog.
On the Search tab, define filter conditions and click Go.
The Results tab displays matching records.
Select one or more values, click Set, and then click OK.
The selected values appear on IPF.
Click Apply to confirm, and Run Report to generate the report with applied filters.