Show TOC

Object documentationQuery Wizard: Select Fields and Sort Orders

 

Use this step to select the required fields from the tables you chose in the previous step and define a sort order for them.

Query Wizard: Select Fields and Sort Orders
Table

From the drop-down list, choose the table in which the required field is found. Only the tables you selected in the previous step and the Comp. option are available here.

Field

Press TAB and choose the required field from the Choose from List window.

This window displays fields from the selected table only.
Heading

Displays by default the field description.

Change this text to display a different heading in the report results.
Sort Order

Use an integer (1, 2, 3) to set the sort priority for the selected field.

Sort Type

Select an ascending or descending order for sorting the query results of a field that has a sort order assigned.

Group (Y/N)

Choose Yes to group the report results according to the results in this field, or leave empty if you do not want to group.

Caution Caution

In grouped rows the computation options are disabled.

End of the caution.
Comp.

This column offers six computation options:

  • Total Records – Displays the number of records retrieved but not the records themselves.

  • Total Distinct Records – Displays the number of distinct records retrieved, but not the records themselves.

  • Amount – Displays the sum of the values of that field in the retrieved records. This option and Average are relevant for fields that contain numeric values, such as quantities and amounts.

  • Average – Calculates and displays the average of the values of that field in the retrieved records.

  • Minimum – Displays the smallest value of this field from within the retrieved records.

  • Maximum – Displays the largest value of this field from within the retrieved records.

Note Note

To cancel a previous selection, click the column and select the blank row from the drop-down box.

End of the note.

Note Note

A row in which one of the computation options is selected cannot be grouped.

End of the note.

More Information

Query Wizard