Add interactivity to the report

This task defines connections between the various controls and sets an active report variable so that the controls can interact with each other when users view the report.

Procedure

  1. Click the interactive behavior icon Interactive behavior icon. of the first data drop-down list control.
  2. Click Create a New Connection.
  3. Click the Target Control drop-down list and click List1.
  4. Ensure that the following information appears in the dialog box and click Connect.
    • In the Behavior drop-down list, Filter is selected.
    • In the Data Item drop-down list for both controls, Core products is selected.
    • In the Active Report Variable box, type Core products Variable 1.
  5. In the Control drop-down list, click Data Drop-Down List2.
  6. Click Create a New Connection.
  7. Click the Target Control drop-down list and click List1.
  8. Ensure that the following information appears in the dialog box and click Connect.
    • In the Behavior drop-down list, Filter is selected.
    • In the Data Item drop-down list for both controls, Countries and regions is selected.
    • In the Active Report Variable box, type Countries and regions Variable 1.
  9. In the Control drop-down list, click Data Drop-Down List1.
  10. In the Behavior on Select section, click the edit button Edit button icon..
  11. Set Countries and regions Variable 1 to Set to Empty and click OK twice.

    When users select a different product in the first data drop-down list control, the second data drop-down list value will reset to the no value list item.

Parent topic: Example - Create an Active Report Showing Revenue Data for Core Products