Navigating from multiple menu items to a single report

You have a list of items displayed in a hyperblock. You want the items to be hyperlinks to another report.

  1. Create a custom hierarchy. In the Hierarchy Designer, switch to unique name view. The captions of the elements will automatically match their unique names. Create a hierarchy with several elements.
  2. In the Table of Names and Text, set the Name attribute of each of the elements to the unique name of the report to jump to.
  3. Drag the custom hierarchy onto the worksheet to create a hyperblock.
  4. Write an ROA formula in a cell with this syntax: =ROA("","","hierarchy name","Name", "Unique name of an element of the hierarchy").
    Normally, the first two arguments of an ROA formula are "database alias" and "data cube". A custom hierarchy or list is not dependent on either an alias or cube so these arguments are left blank (""). The third argument of an ROA formula is normally a dimension name. Here, "Hierarchy name" is used instead. ’Name’ is the attribute of the hierarchy.
    Note: The Name attribute is case-sensitive, so use ’Name’ not ’name’.
  5. Right-click the value cell of the hyperblock and select Define Action.
  6. Select Hyperlink as the mode.
  7. Select =TRUE as the condition.
  8. Select Jump as the type.
  9. Click the browse button in the Value field of the Target Report to open the Target Report dialog.
  10. Select Enter a cell reference or formula to specify the target object and enter a reference to the cell containing the ROA formula (for example, =B8).
    In View Mode, the elements of the hyperblock are now hyperlinks. Click the hyperlinks to go to the target report.