Stored Procedures

Applies to: Kyvos Reporting

A stored procedure (SP) is a precompiled collection of SQL statements and logic stored on the database server. Stored procedures can be cached, reused, and executed on demand, offering performance benefits in terms of data retrieval and report rendering.

You can use stored procedures in SQL Designer to design Studio reports based on procedural logic.

Selecting a Stored Procedure

To use a stored procedure in SQL Designer:

1. In the top-left corner of the SQL Designer window, select the Procedure radio button under the Object List.

2. The Stored Procedure tab is enabled, and the Design tab is automatically disabled.

3. Drag the required stored procedure to the SQL Parser pane.

Once you drop the stored procedure into the SQL Parser, the Stored Procedure Parameters pane is populated. You must map each parameter by assigning either a fixed value or a user-defined parameter in the UDFParams column.