Navigating between reports

You have several reports and want users to be able to navigate between them by selecting a report name from a selection list.

  1. In the Report Catalog, right-click each of the reports you want to navigate between and select Properties. Make a note of the unique name of each report.
  2. Create a custom hierarchy, with the reports as its elements. Use the unique names of the reports as the unique names in the hierarchy and their visible names as the captions.
  3. Create a combo box in the first of the reports and drag the custom hierarchy onto it.
  4. Open the Format Listview dialog of the combo box and note the name of the combo box, for example, ListView5.
  5. Select a blank cell and enter a reference to the combo box in it. For example, "=ListView5.text".
    The unique name of the value selected in the combo box is displayed in the cell. Note the cell in which you enter the reference.
  6. Open the Object Properties dialog of the combo box. In the Action section on the General tab, select the Perform action, when selection changes check box. Then click the browse button to open the Define Action dialog.
  7. Select Jump as the type.
  8. Select =TRUE as the condition.
  9. Select Selection changed as the mode.
  10. Click the browse button in the Value field of the Target Report input.
    The Target Report dialog is displayed.
  11. Click Enter a cell reference or formula to specify the target report.
  12. Enter the reference of the cell in which you entered the reference to the combo box. Prefix the reference with the equals (=) sign. For example, =D1.
  13. Click OK.
    When you select a report name from the combo box, the selected report opens. To navigate between all the reports in the combo box, copy the combo box and cell reference to it into each of the reports. Or, use the combo box in a template and create the reports from that.