Sort

The Sort web action enables you to sort the records in a banded object.

To bind the Sort web action to a web control:

1. Insert the required web control into your report by dragging it from the Toolbox panel.
2. Right-click the web control, and then select Display Type from the shortcut menu.
3. In the Web Behaviors box of the Display Type dialog, choose an event from the Events column, then click in the Actions column and click that appears in the text box.
4. In the Web Action List dialog, select Sort and click OK. The Sort - Web Action Builder dialog appears. See the dialog.

   

5. From the Get Input From drop-down list, specify where to get the web control, which may be a form, or other in report.
6. From the Apply Action To drop-down list, select a banded object whose records will be sorted.
7. In the Sort On column, specify the field on which to sort the records. The field may be a column in the banded object, or be specified by the value of a web control.
8. Specify the sort value. The value may be Ascending or Descending, or be the value of a web control.
9. If necessary, click to add a new sort condition.

   To delete a sort condition, select it and click . To adjust the order of the sort conditions, click or .

10. Click OK to accept the settings.

See also Sort - Web Action Builder dialog for details about options in the dialog.