Compiling SQL

Applies to: Kyvos Reporting

Result Tab

When you select the Result tab, the defined SQL statement is compiled.

If the SQL compiles successfully, the result set is displayed in the same tab.
If there are errors in the SQL, they are shown in the tab along with the error location and details. This allows you to identify and correct issues before using the SQL in the Layout Designer.

Note

If your SQL statement includes parameters, you’ll be prompted to enter parameter values before the query runs.

Viewing SQL Results

The Result tab displays output based on the SQL statement defined in the Edit tab. This helps you validate whether the SQL is returning the expected data before proceeding with layout design.

Tip

Ensure all required parameters have values assigned before running the query. This prevents errors and enables a complete preview of the result set.