Use this step to select the required fields from the tables you chose in the previous step and define a sort order for them.
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. |
Press TAB and choose the required field from the Choose from List window. This window displays fields from the selected table only. |
Displays by default the field description. Change this text to display a different heading in the report results. |
Use an integer (1, 2, 3) to set the sort priority for the selected field. |
Select an ascending or descending order for sorting the query results of a field that has a sort order assigned. |
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 In grouped rows the computation options are disabled. End of the caution. |
This column offers six computation options:
Note To cancel a previous selection, click the column and select the blank row from the drop-down box. End of the note. Note A row in which one of the computation options is selected cannot be grouped. End of the note. |