Dropdown and Option

Applies to: Kyvos Reporting

When a parameter's Input Type is set to Dropdown or Option, you can configure the list of values in one of two ways:

To Set Predefined Values

Use predefined values when the parameter values are known in advance and are not dependent on external data sources.

Steps:

1. In the Dropdown Source section, select Pre-Defined.

2. In the Display Name field, enter the label to be shown on the Input Parameter Form (IPF).

3. In the Value field, enter the value that will be passed during report execution.

4. Click the Add button to include the value in the list.

5. Optionally, click the Upload button to import a list of values from a file. When uploading, you can specify the Enclosed By, Separator, and other file-specific parsing options.

Open

List Management Options:

To Set Dynamic Values

Use dynamic values when the dropdown list needs to reflect data stored in a database.

Steps:

1. In the Dropdown Source section, select Dynamic.
   
   

   Open

   

2. In the Source Statement field, enter the SQL query to fetch the values.

   • Tip: You may enter just the table name (e.g., PRODUCT) instead of writing the full SQL (e.g., SELECT * FROM PRODUCT).

3. Click Verify to validate the query.

   • If the query is valid, its fields will be available in the Display Column and Value Column dropdowns.

   • If invalid, an error message will appear.

4. In Display Column, select the field to be shown to users on IPF (e.g., SALESPERSON).

5. In Value Column, select the field whose values will be used during report execution (e.g., SALESPERSONID).

Displaying Parameter Name as a Report Control

You can also use a parameter as a control element on a report layout.

• Check the Display Parameter Name option and specify a name.

• This name will appear as a report control in the report designer, allowing you to drag and drop it onto the Canvas.