Creating ascending or descending sorts in a report

You have a hyperblock in a report and want users to be able to sort its contents in ascending or descending order by selecting Ascending or Descending from a combo box.

  1. Create a custom hierarchy.
  2. Add a parent node and name it Ascending.
  3. Add a sibling node and name it Descending.
  4. Click Show Unique Names.
    node and node2 are displayed. These are the unique names of the nodes.
  5. Select node and press <F2> to make it editable. Rename it ASC.
    Note: Unique names are case-sensitive: "Asc" will not work.
  6. Rename node2 as DESC.
    Note: Unique names are case-sensitive. "Desc" will not work.
  7. Create a combo box in a report and drag the custom hierarchy onto it. The combo box displays Ascending and Descending.
  8. Create a hyperblock from a dimension. Select the hyperblock and select Sorting in the List Designer.
  9. Click New Sorting Criterion.
  10. In Sorting Criteria Settings, select Caption as the type.
  11. Select <Edit Formula> as the Order.
    The Edit Formula dialog box is displayed.
  12. In the Edit Formula dialog box, expand Listviews and double-click the name of the combo box which contains the custom hierarchy. This is then displayed in the right-hand pane (for example, =ReportObjects.ListView3.text).
  13. Click OK.
  14. In List Designer, save the changes to the list.
  15. View the report in View Mode.
  16. Select 'Ascending’ or 'Descending’ from the combo-box to change the order of the elements in the hyperblock.
Parent topic: Custom hierarchies