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.

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.
Create a custom hierarchy called FoodandDrink. Create elements with Eggs, Beans, Crumpets, Gin, Whisky and Vodka as their captions.
We will not use the unique names of these elements. This is because the selection list will have multiple links to the same reports and a unique name can only be used once in a list. So, you do not need to amend the unique names that are automatically generated for the elements ( Node, Node2 etc.).
We link the elements Eggs, Beans and Crumpets to the Foods report and Gin, Whisky and Vodka to the Drinks report by using the Name attribute of the custom hierarchy. Multiple elements can have the same Name attribute.
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.
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.
Create a report with a combo box linked to the FoodandDrink custom hierarchy. Note the unique name of the combo box.
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.
Open the Object Properties 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.
Select Selection changed as the mode.
Select =TRUE as the condition.
Select Jump as the type.
In the Value field of the target report, click the browse button to open the Target Report dialog. Click 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.