Working with Studio Reports SQL Designer

Applies to: Kyvos Reporting

You can manually design pixel-perfect reports in Kyvos Reporting Studio using the SQL Designer. This tool allows you to retrieve data from the connected database by defining queries through a visual interface. You can then use the retrieved data to design and format your report layout.

To begin, launch Kyvos Reporting Studio and open the SQL Designer.

To open SQL Designer:
In Kyvos Reporting Studio, go to Tools > SQL Designer.

The Query Window opens.

Select the Specify SQL option to enable the SQL Designer button.
Click SQL Designer to open the designer interface.

The SQL Designer displays the date and time when the database schema was last refreshed.

SQL Designer Interface

The SQL Designer is organized into three primary panes:

Diagram Pane: Allows you to drag and drop database objects such as tables and views.
Designer Pane: Lets you define actions on selected objects, including joins, filters, and deletions.
Parser Pane: Displays the SQL query being generated based on actions performed in the designer.

Note

You can resize any pane for better visibility by dragging the borders between panes.

Warning

You must define an SQL query to design a report. Without a valid query, report design cannot proceed.

Key Features

You can perform the following actions using the SQL Designer:

Select database objects to use in your report.
Create and manage join conditions between related tables.
Validate and save queries for reuse.

Refer to the next sections for detailed instructions on: