Navigating between reports from a list containing multiple links to the same reports

You have two or more reports and two or more jumps to each of them. You want users to be able to navigate to the reports from a single selection list.

To illustrate this problem we will create two reports called Foods and Drinks. We will create a third report to hold a single selection list for navigating between them. The selection list will contain several food items and several drink items. Selecting a food item will take users to the Foods report and selecting a drink item will take them to the Drinks report.

  1. Create the Foods and Drinks reports. Right-click on them in the Report Catalog and select Properties. Change their unique names to Foods and Drinks.
  2. Create a custom hierarchy called FoodandDrink. Right-click the hierarchy and select Edit. Create elements with Eggs, Beans, Crumpets, Apples, Orange and Pineapple as their captions.
  3. In the Hierarchy Designer, open the Table of Names and Texts by clicking Show Table of Names and Texts.
    Note: You will find it helpful if clicking on an element in the hierarchy automatically highlights the correct Name attribute in the Table of Names and Texts. If this does not happen, click Synchronize the Selection of the Hierarchy and the Table of Names and Texts.
  4. In the hierarchy, click each of the food items and change the Name attribute in the Table of Names and Texts to the unique name of the Foods report. In the same way, link each of the drink items to the unique name of the Drinks report.
  5. Create a report with a combo box linked to the FoodandDrink custom hierarchy. Note the unique name of the combo box.
  6. In a cell of the report, enter the formula =ComboBoxName.attribute. The cell displays the unique name of the Foods or the Drinks report, depending on which item is selected in the combo box.
    Note: Note the reference of the cell in which you entered the formula.
  7. Open the Format Listview dialog of the combo box. On the General tab, click Perform action, when selection changes and click the browse button to open the Define Action dialog box.
  8. Select Jump as the type.
  9. Select =TRUE as the condition.
  10. Select Selection changed as the mode.
  11. In the Value field of the target report, click the browse button to open the Target Report dialog. Select Enter a cell reference or formula to specify the target object. Enter the reference of the cell in which you put the =ComboBoxName.attribute formula (e.g. "=A2"). Click OK.
    In View Mode, when you click on any of the food items in the combo box, the Foods report opens. When you click any of the drink items, the Drinks report opens.