Hyperlink - Web Report

Application Scenario

You can drill down to other reports under this project by clicking the hyperlink, as shown in the following figure.

Function Description

Method to add a linked report: opening the report project directory and selecting a template.

Three built-in ways to open links: New Window, Dialogue Box, and Current Window.

You can pass parameters using hyperlinks. For details, see Hyperlink Parameter Passing. 

Two reports Order Overview Table and Order Detail Table are created in the example, and you can view the detailed information of an order ID in Order Detail Table by clicking the order ID in Order Overview Table.

Creating the Order Detail Table

1. Create a dataset ds1 with the SQL statement SELECT * FROM OrderDetails_new WHERE "Order ID"='${OrderID}'.

Note: 

The parameter OrderID in the SQL statement will be used in parameter passing by hyperlink to display the corresponding detailed information by clicking the order ID.

2. Design the table of the order detail table, and drag the fields in the dataset into the corresponding cells, as shown in the following figure.

3. Save the report to %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\SpecialSubject\HyplinkReport.

Creating the Order Overview Table

1. Create a dataset ds1 with the SQL query statement SELECT * FROM Orders.

2. Design the table of the order overview table, and drag the fields in the dataset into the corresponding cells, as shown in the following figure.

Select cell C2, modify the format to Date, and select yyyy-MM-dd in Cell Element.

Select cell D2, modify the format to Number, and select #0.00 in Cell Element.

Hyperlink Adding

Select cell A2 where the field Order ID is located, click the Hyperlink icon on the right attribute panel, add a Web Report hyperlink, and configure the hyperlink as shown in the following:

Web Report: click Select, and add the path of the order detail table from the directory.

Link Opened In: select Dialogue Box, after which you can open the order detail table in a dialogue box by clicking the hyperlink.

Add a parameter OrderID and enter the formula =$$$ as the value. The parameter name should be the same as that in the order detail table, and $$$ indicates that the parameter value is the current cell. Then, you can pass any ID to the order detail table by clicking the order ID.

Effect Display

Save the template and click Pagination Preview. The effect is shown in section "Application Scenario."

The template can be previewed on the DataAnalyst and HTML5 apps.

For details, you can download the templates:

Order Overview Table.cpt

Order Detail Table.cpt

Linking to the Data Entry Template

If you want to open the linked data entry template in the data entry preview mode, you can add the parameter &op=write to the end of the report path, as shown in the following figure.

Opening Hyperlinks in the Platform

If you want to open the template mounted to the decision-making platform in the current tab or a new tab within the platform by clicking the hyperlink, you can install the Tab Opening Within Platform plugin to achieve the effect. After you install the plugin, two more opening methods are added in the Link Opened In setting, as shown in the following figure.