Linking Reports

This tutorial illustrates how to link the Orders report to the CustomerInfo report. These features of the linking process are highlighted:

• Creating links between two reports

• Passing parameters from one report to the other

  NOTE-

  It is common practice to update the color of items being linked to blue (using the properties dialog box) to indicate that the item is a hyperlink. This is illustrated in the video for this tutorial.

To link reports:

1. Right-click the item on the form to link to another report (in this tutorial, the Orders report is linked to the CustomerInfo report using the CUST_CODE item in the Orders Layout form), and then select Properties.

The Textbox properties dialog box displays.

2. Click Advanced, and then select the Navigation tab.

The Navigation tab of the Advanced Textbox Properties dialog box displays.

3. Select the report to link from the Jump to report drop-down listbox (in this tutorial, the CustomerInfo report is selected), and then click Parameters.

The Parameters dialog box displays.

4. Select the parameter name from the Parameter Name drop-down listbox (in this tutorial, the CustNumber parameter name is selected).

5. Select the parameter value from the Parameter Value drop-down listbox (in this tutorial, the =Fields!CUST_CODE.Value parameter value is selected).

6. Click OK, and then click OK again.

7. Select the Preview tab from the report design environment.

The report is compiled and displays in the Preview tab.

Note that clicking the customer number from the Orders report opens the CustomerInfo report. To return to the Orders report, click the Back button.