Run-Dry Set calculation report rendered output hyperlink drillthrough

after the presentation of the report, it is often necessary for the data in the table to drill, such as summary data drill to detail data, the parent unit drill to subordinate units. The drill-down hierarchy often has multiple layers, which requires the report tool to support drillthrough.

run-Dry Set calculation reports support hyperlink drilling, can meet the needs of the report user data drillthrough. Here's an example to look at.

1 , new summary report

Here is an example of an annual Sales summary report by region, click on the region to drill to the appropriate region to place order details. Set the year for the report years parameter , and edit the report expression as follows:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/D0/wKioL1S9zEXhQhiLAACoxAyvUAo055.jpg "style=" float: none; "title=" report5_output_link_1.jpg "alt=" Wkiol1s9zexhqhilaacoxayvuao055.jpg "/>

2 , set hyperlinks

In the Properties panel on the right side of the designer , set the A3 underground link expressionin the hyperlink- hyperlink expression edit box to: "reportjsp/showreport.jsp?rpx= detail.rpx&year= "[Email protected]+" &area= "+a3, the yearand region (A3 cell) Parametersare passed for the detail report .

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/D3/wKiom1S9y3OiyvOrAADzI51GkYU554.jpg "style=" float: none; "title=" report5_output_link_2.jpg "alt=" Wkiom1s9y3oiyvoraadzi51gkyu554.jpg "/>

for report hyperlinks, if the hyperlink string does not need to be dynamically generated, you can directly write the page path to which you want to link, you can edit it directly in the Hyperlink property value edit box, or if the hyperlink string needs to be dynamically generated from a cell or parameter value, enter an expression.

a hyperlink path can be a relative path or an absolute path. Relative paths are relative to the application path, such as:/reportjsp/showreport.jsp, the system will automatically add the application path after the operation. The absolute path must be complete, including the transport protocol. For example:http://www.raqsoft.cn, not only write www.raqsoft.cn.

In addition, the hyperlink window is the target window that the hyperlink displays on the Web page, which, if not written, defaults to _self.

3 , edit detail Report

The detail report is the target report for the summary table drillthrough, which sets the report parameter year and region parameter area , which is used to receive the parameters of the hyperlink pass. Edit the report expression as follows:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/D0/wKioL1S9zEeBxLvHAAC82elUYVA955.jpg "style=" float: none; "title=" report5_output_link_3.jpg "alt=" Wkiol1s9zeebxlvhaac82eluyva955.jpg "/>

4 , write DataSet SQL Complete Data filtering

In the data set using parameter filter data, belongs to the production category with the parameter report, the specific use can refer to the Set Calculation Report tutorial, here no longer detailed.

5 , Show effect

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/D3/wKiom1S9y3bQ4ypTAAF8lv9eCqw859.jpg "style=" float: none; "title=" report5_output_link_4.jpg "alt=" Wkiom1s9y3bq4yptaaf8lv9ecqw859.jpg "/>

This article is from the High performance report data calculation blog, so be sure to keep this source http://report5.blog.51cto.com/8028595/1606056

Run-Dry Set calculation report rendered output hyperlink drillthrough