Slider

Applies to: Kyvos Reporting

This configuration is applicable when the Input Type for the parameter is set to Slider. The Slider input allows users to select a single value or a continuous range of values. It is supported for parameters with Number or Date data types.

You can configure the slider with either predefined values or dynamic values fetched from a database.

To Set Predefined Values

Use this option when the minimum and maximum range values are known in advance.

Steps:

1. Under Slider Source, select Pre-Defined.

2. In the Minimum and Maximum fields, specify the range of values to be displayed on the Input Parameter Form (IPF).

3. In the Step field, enter the increment value used to move the slider.

4. For parameters with a Date data type, specify the Time Level to be used as the step unit (for example, day, month, or year).

Open

To Set Dynamic Values

Use this option when the slider's range must be based on data retrieved from a database.

Steps:

1. Under Slider Source, select Dynamic.

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

3. Click Verify to validate the SQL.

   • If the query is valid, the result fields will be available in the Minimum Column and Maximum Column dropdowns.

   • If invalid, an error message will be displayed.

4. In the Minimum Column and Maximum Column dropdowns, select the fields whose values define the range of the slider.

5. In the Step field, enter the value that determines the slider increment.

6. For Date type parameters, specify the Time Level (e.g., day, month, year) to define the unit of increment.