Hyperlinking Studio Reports Fields

Applies to: Kyvos Reporting

You can configure a report component as a clickable hyperlink, allowing users to navigate to a URL or another report. This feature enables drill-down and linked report capabilities in Kyvos Reporting.

Hyperlink to a URL

To open an external website or application when a component is clicked:

Open the report in Kyvos Reporting Studio.
Right-click the component to be hyperlinked and select Hyperlink, or press Ctrl+K.
In the Hyperlink Options dialog box, select the URL option.
In the textbox below, enter the desired URL.
Click Apply, and then click OK.

When the report is run, clicking the component opens the specified URL in a browser.

Hyperlink to Another Report (Drill-down Report)

To link a component to another report:

Open the report in Kyvos Reporting Studio.
Right-click the component to be hyperlinked and select Hyperlink, or press Ctrl+K.
In the Hyperlink Options dialog box, select DrillDown to another report.
From the Select dropdown, choose the target report to open when the hyperlink is clicked.
Under Target, select how the report should open:

Target Option	Description

Target Option	Description
New Window	Opens the report in a new browser tab.
Same Frame	Opens the report in the same browser frame.
Parent Frame	Opens in the parent frame with a navigation panel.
Parent Window	Opens in the main application window.

Under Report Parameters, specify:
- Report Parameter: A parameter expected by the linked report.
- Value Field: A field from the source report to pass as the value.
Under System Parameters, set optional system-level configurations (see below).
Optionally, provide a Save File Name for use when the linked report is published.
Click Apply, and then click OK.

System Parameters

Use system parameters to control the runtime behavior of the linked report.

Parameter	Description

Parameter	Description
Priority	Set to `low`, `medium`, or `high`.
SYS_REPORT_FORMAT	Format of the output: `HTML`, `ACROBAT PDF`, `MS EXCEL`, `XML`, `TEXT`, `MS WORD`, `COMMA SEPARATED`, `INTERACTIVE`, or `SYS_REPORT_FORMAT` to use parent report format.
Report Connection Name	Specify the database connection to use.
Implicit Operation	Select `Publish` if the report should be published instead of just viewed.
Refresh Data	Enable fetching fresh data at runtime.
Prefetch Drilldown	Enable generation of the linked report in advance.
Pagination	Options: Single Page – Unlimited width and height Multiple Page – Page width and height limits Horizontal Breaks – Break only in length
Show HTML Toolbar	Options: `Yes`, `No`, or `Multipage` (shows toolbar only for multi-page reports).
Append to Parent Report	Applicable when exporting to PDF/PPT, and Prefetch Drilldown is enabled. Set `True` to merge child reports into the parent report. Set `False` to export only the parent report.

Note

Use <%field_name%> to embed dynamic field values in parameters or messages.

About Prefetch Drilldown

When a report contains hyperlinks to other reports (drill-down reports), those reports are normally generated only when the hyperlink is clicked. This may result in a delay, especially for large reports.

To reduce wait time, enable Prefetch Drilldown, which generates the child reports along with the parent report before the hyperlink is clicked.

Behavior

The child report is pre-generated and stored in .rpg format on the report server.
When the hyperlink is clicked, Kyvos Reporting retrieves the pre-generated report, resulting in faster response time.

Retention

Scenario	Retention Duration

Scenario	Retention Duration
Published Parent Report	Child reports are retained for the same duration as the parent report.
Viewed Parent Report (HTML)	Child reports are retained until 11:59:59 PM on the same day. They are deleted automatically at midnight.