SQL

Applies to: Kyvos Reporting

This applies when the parameter’s input type is set to Dropdown or Option. You can dynamically fetch values from a database using an SQL query.

To get Dynamic Values

1. Under Source, select Dynamic.

2. In the Source Statement field, enter the SQL query to fetch data.
   Tip
   To retrieve all fields from a table, you can specify only the table name (for example, PRODUCT) instead of writing the full query (such as SELECT * FROM PRODUCT).

3. Click the Verify button.

   • If the SQL is valid, the fields returned by the query are listed in the Display Column and Value Column dropdowns.

   • If the SQL is invalid, an error message appears below the SQL field.

4. In Display Column, select the field to show on the Input Parameter Form (IPF). For example, SALESPERSON.

5. In Value Column, select the field to be used as the filter input. For example, SALESPERSONID.

Using a Parameter as a Report Control

You can use a parameter as a control in the report layout, similar to other fields.

• Check the Display Parameter Name checkbox.

• Enter a name that will appear in the Report Designer.

• You can drag and drop this control onto the Canvas (report layout area).