Using a variable for sorting

Create the Product hyperblock.

Create a global variable named gv_SortingASCDESC and set its value to DESC.

Select the hyperblock and click New Sorting Criterion in the Sorting pane of the List Designer.

In Sorting Criteria Settings, select Type > Unique name.

Select Order > <Edit Formula>.

The Edit Formula dialog is displayed.

Double-click gv_SortingASCDESC in the list of global variables and click OK.

In View Mode, the elements of the Product list are sorted in descending order. Change the value of the variable to ASC to display the list in ascending order.

To change the value of the variable by selecting from a combo box.

See Creating ascending or descending sorts in a report.