Accessing Parent Report’s Data from Sub-Report

This documentation is for Kyvos 2026.2.x. To view documentation for other Kyvos versions, click here.

This documentation is for Kyvos 2026.2.x. To view documentation for other Kyvos versions, click here.

Applies to: Kyvos Reporting

Sub-reports in Kyvos Reporting can access data from their parent report by referencing the parent report’s fields as parameters. These parameters are automatically created when you embed a sub-report. However, when using a referenced sub-report, you must manually define the parameters in the sub-report.

Parameter Mapping

Field values from the parent report are passed to the sub-report as parameters. The parameter names are the same as the field names (or aliases, if used) from the parent report.

Example:

Parent report SQL:
SELECT ORDERS.ORDER_NO, ORDERS.ORDER_DT FROM ORDERS
Sub-report parameters:
ORDER_NO, ORDER_DT
Sub-report SQL:
SELECT ORDRDETL.ORDER_NO, ORDRDETL.PROD_NO, ORDRDETL.PRICE, ORDRDETL.QTY FROM ORDRDETL WHERE ORDRDETL.ORDER_NO = <%ORDER_NO%>

Guidelines

When using embedded sub-reports, Kyvos Reporting automatically creates the required parameters.
When using referenced sub-reports, you must manually create these parameters using the same names (or aliases) as used in the parent report.
You can use these parameters in the sub-report layout or directly within SQL queries as filters.

Handling Duplicate Field Names

If the parent report includes multiple fields with the same name from different tables (e.g., product.prod_no and invoice.prod_no), use aliases in the parent report SQL to avoid conflict.

Example:

SELECT product.prod_no AS PprodNo, invoice.prod_no AS InvProdNo FROM product, invoice

In the sub-report, use the parameters PprodNo and InvProdNo accordingly.

Important

When using a numeric parameter as a filter in sub-report SQL, ensure that a default value is set for that parameter. Omitting a default value may result in a SQL error.

Using Stored Procedures in Sub-Reports

Stored procedures can be used in sub-reports in the same way as in the parent report. Configure the data source to use a stored procedure, pass required parameters from the parent report, and define the output structure accordingly.