Previous Topic  Next Topic

Edit Sort and Filter Dialog Box

You can use the Edit Sort and Filter dialog box to predefine the sort and filter conditions for the specified data component in a page report. This topic describes the options in the dialog box.

Designer displays the Edit Sort and Filter dialog box when you select a table, chart, crosstab, or banded object in a query-based page report and select Report > Edit Sort & Filter.

You see the following options in the dialog box:

Sort tab

Use this tab to define the sorting conditions.

• Fields
  The box lists all fields that are available to be sorted on.
• Add button
  Select to add the specified fields in the Fields box to the Sort By box.
• Remove button
  Select to remove the selected fields from the Sort By box.
• Sort By
  The box lists the fields by which you select to sort the report data (the sort-by fields).
  • Direction
    The column shows the sort order that you specify for the sort-by fields.
  • Name
    The column shows the field names.
• 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.

Filter tab

Use this tab to define the filter conditions. Designer displays the same options in the tab as in the Edit Filter dialog box.

Edit Display Name

Select to open the Edit Display Name dialog box to add or remove display name fields.

OK

Select to apply all changes and close the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

Previous Topic  Next Topic