Linking Parameters

Applies to: Kyvos Reporting

In some reports, multiple parameter values are interdependent—meaning the value of one parameter determines the available values for another. This setup is known as linked or cascading parameters.

Example

Consider two parameters: Countries and States.

• When you select a country (e.g., India), the States parameter automatically filters to show only the states belonging to that country.

• This improves user experience and ensures meaningful value combinations are selected at runtime.

Steps to Link Parameters

To configure linked parameters:

1. Enable Linking

   • Select the Link checkbox for the dependent parameter (e.g., States).

2. Choose Parent Parameter(s)

   • Click the ellipsis button beside Select Source Parameter(s).

   • Select one or more parameters from the list to act as parent(s) (e.g., Countries).

3. Modify the SQL for the Dependent Parameter

   • In the Dynamic Source Statement, reference the parent parameter(s) using this syntax:

     <%ParameterName%>

   • For example, to filter cities based on the selected state in parameter Prm_Link2, use:

     SELECT DISTINCT city FROM Country WHERE state IN (<%Prm_Link2%>)

Behavior at Runtime

• Both parent and dependent parameters appear on the Input Parameter Form (IPF).

• When a user selects a value for the parent parameter (e.g., a state), the dependent parameter (e.g., cities) auto-populates with values relevant to that selection.

• This ensures valid and filtered selections for improved report accuracy and usability.