I. Description
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:
II. Example
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