You can use the Custom Sort dialog box to customize the sort manner of the groups at the specific group level in a table/banded object/shape map, or the sort manner of the category/series/group values in a chart. This topic describes the options in the dialog box.
Designer displays the Custom Sort dialog box when you select Custom Sort from the Sort column in the Group screen of the component wizard, or from the Based On drop-down list in the Category Options dialog box, Group Options dialog box, or Series Options dialog box.
Designer displays these options:
This box lists the data fields in and related to the data resource the data component uses, which you can add as the sort-by fields.
Sort Group By
This column lists the fields by which you add to sort the groups.
This column shows the order by which you select to sort the groups based on the sort-by fields.
Select to sort the groups by the values of the first record in each group on the specified field in an ascending order.
Select to sort the groups by the values of the first record in each group on the specified field in a descending order.
Select to add the specified field in the Resources box as the sort-by field.
Select to remove the specified sort-by field.
Move Up button
Select to move the specified sort-by field higher in the list. The order of the sort-by fields determines the sort priority of the fields.
Move Down button
Select to move the specified sort-by field lower in the list.
Select to apply your settings and close the dialog box.
Select to close the dialog box without saving any changes.
Select to view information about the dialog box.