Hyperlink-Pass Multiple Values

When setting a hyperlink to realize data drilling, there may be multiple values in some cells. At this time, how to query the data of all values in the subreport? As shown below:

1. Main table settings

1) Open the template

Open the template:%FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Advanced\Data_Drilling_main.cpt.

2) Modify the data set

Modify the data set to query less data. For example, modify the data set to: SELECT * FROM ORDERS where ORDERID <10004, only query data with ORDERID<10004.

3) Modify extended attributes

Set the expansion properties of all cells containing data columns to not expand.

2. Sub-table settings

1) Open the template

Open the template:%FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Advanced\Data_Drilling_sub.cpt.

2) Modify the filter conditions

Change the original ORDERID equal to the parameter ID to the ORDERID included in split($ID,","), as shown below:

3. Effect view

Page preview the main table, click on the order ID, you can see the sub-table shows all the order ID information of the cell, as shown in the above rendering.

Keywords: Hyperchain transfer multiple values