#### 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 18-4.

Figure 18-4 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:

- Select Report Design then choose the Browse For File button and navigate to the target report design.
- Select Report Document then choose the Browse For File button and navigate to the target report documemt.

3. In Select a target anchor, complete one of the following tasks:

- Select Target Bookmark then select a bookmark from the drop-down list.
- Select Table of Contents Entry in Target Report then select a bookmark from the drop-down list.

4. In Create a link expression that matches the target bookmark, choose the ellipsis button and build an expression, for example row["CUSTOMERNAME"].
5. In Show target report in, select one of the following options:

- Same Window
- New Window

6. In Format the target report in, select one of the following options:

- HTML, if the target report is in HTML format.
- PDF if the target report is in PDF format.

Figure 18-5 shows sample entries in Hyperlink Options.

Figure 18-5 Hyperlink properties drill-through options sample entries
Choose OK.