Example - controlling dependent lists with variables

Selecting an element from a combo box determines the display of a list held in a hyperblock.

  1. Create a combo box on the worksheet.
  2. Link the combo box to the Period dimension.
  3. In the List Designer click the Select Level icon and select Quarters from the list. The combo box displays only the quarters elements.
  4. Create the report variable rv_period.
  5. Right-click the combo box and select Object Properties. Specify rv_period as the output variable.
  6. Create a hyperblock and link it to the Period dimension.
  7. Select the hyperblock. In Structure Selection, click Select Children and select <Edit Formula> from the Element drop down list in Selection Settings.
  8. In the Edit Formula dialog, click Variables and double-click rv_period.
  9. Apply the changes to the list.
    In View mode, as you select different quarters from the combo box, the list in the hyperblock displays the appropriate months.