> #### How to link two reports

> 1 | In the source report, select the source report element. Property Editor displays the properties of the selected report element.

> 2 | On Property Editor, under Properties, select Hyperlink. The hyperlink properties appear, as shown in Figure 19‑6.

> Figure 19-6 | Hyperlink properties

> 3 | Choose the ellipsis button.

> 4 | On Hyperlink Options, complete the following tasks:

> 1 | In Select hyperlink type, choose Drill-through.

> 2 | In Select a target report, complete one of the following tasks:

> o | Select Report Design then choose the Browse For File button and navigate to the target report design.

> o | Select Report Document then choose the Browse For File button and navigate to the target report document.

> If the target report has parameters, Report Parameters is enabled.

> 3 | To set the value for a report parameter in the target report, perform the following steps:

> 1 | Select the field below the Parameters column heading.

> 2 | Select a parameter name from the drop-down list in this field.

> 3 | Select the field below the Required column heading. A check mark appears if the target report requires a value for this parameter.

> 4 | Select the field below the Values column heading.

> 5 | Type an expression in this field, or choose the ellipsis button to build an expression.

> To set the values for remaining parameters in the target report design, perform these steps in further empty rows in Report Parameters.

> 4 | In Select a target anchor, complete one of the following tasks:

> o | Select Target Bookmark then select a bookmark from the drop-down list.

> o | Select Table of Contents Entry in Target Report then select a table of contents entry from the drop-down list.

> 5 | In Create a link expression that matches the target bookmark, choose the expression builder button and build an expression, for example, row["CUSTOMERNAME"].

> 6 | In Show target report in, select one of the following options:

> o | Same Window

> o | New Window

> 7 | To choose an output format that is not HTML, select Format the target report in. Then, in Format the target report in, select one of the available options.

> Figure 19‑7 shows sample entries in Hyperlink Options.

> Figure 19-7 | Hyperlink properties drill-through options sample entries

> Choose OK.

(c) Copyright Actuate Corporation 2008