Using SQL Parser

Applies to: Kyvos Reporting

The SQL Parser in SQL Designer provides several tabs that help you build and manage SQL queries. Each tab supports a specific task in the query design process.

Open

• Design – Create the SQL statement using a visual design interface.

• Procedure – Use data returned from stored procedures.

• Edit – Modify the SQL statement manually.

• Result – View the output generated from the SQL statement.

• Filters – Set filter conditions to accept values at report run time.

• Sort – Define sort levels that can be applied during report execution.

• OK – Save and apply the changes made.

• Cancel – Discard changes and close the dialog.

The formatted SQL statement appears at the bottom of the SQL Designer dialog box. It is generated based on the selections made in the above tabs and can be manually edited if required. This helps streamline query creation and customization.

Add Label

To assign a descriptive label to the SQL or a specific section:

• Use the Add Label option, if available, to help identify or document parts of the SQL logic.