Sorting Report Data
You can sort the records in a banded object or table, and the groups in a certain group level of the banded object or table if you have defined one or more group levels.
- Sorting records: Changing the order of records in the whole banded object or table, or in each group if there exists one or more group levels. The sorting scope is the whole banded object or table.
- Sorting groups at a group level: Changing the order of groups at the specified group level, that is, the groups will be sorted by value of the first record in each group on the related field. The sorting scope is the group level.
You can achieve the above by using the Sort dialog or shortcut menu. However you cannot sort the data by a global level formula.
Below is a list of the sections covered in this topic:
- Select Menu > Report > Sort, or the Sort button on the toolbar.
- From the Sort in Scope drop-down list, select a banded object/table or a group field on which the sort condition will be based.
- From the field drop-down list, select the field on which to sort the data, then set the sort order to Ascend or Descend.
- If you select a banded object/table in step 2, you can select to add new rows of sorting conditions if required. When a group field is selected, only one sort condition can be composed.
Select or to move a row up or down so as to set the sorting priority, and to delete the corresponding sorting condition if it is unwanted.
To retrieve the opening status of this dialog, select the Reset button.
- Select OK to accept the settings and to reload the result.
- Point to any value of a field by which to sort the data in the banded object/table, and then right-click.
- Choose the command Sort > Ascend or Sort > Descend from the shortcut menu.
If you right-click on a detail/summary field value in step 1, the sorting will affect the order of detail/summary records in the banded object or table; if it is a group field value, the order of groups in the group level represented by the group field will be rearranged.
To remove the sort condition, select Sort > No Sort.
When you use the shortcut menu to sort the report data by a field and then by another field, the later sort condition always replaces the former one. And after applying a sort using the shortcut menu, if you open the Sort dialog you can find the corresponding sort expression displays in the dialog.
- Administrators can customize the buffer size for sorting of each report so as to improve performance.
- Using Logi JReport Designer, you can bind a field to a label to enable the Sort shortcut menu on the label, and show the sort button beside the label for easy sorting. For details, see "Enabling Sort and Filter on Labels" in the Logi JReport Designer User's Guide.