• Home
  • Sales
  • Service
  • Parts
  • Office
  • Administration
  • Search

Select the Report Fields to be Sorted

  • How To
  • Step by Step

Select the Report Fields to be Sorted

Report Writer select field

To select the report fields to be sorted:

  1. From the Available Sortable Fields list, select the fields to be sorted.
    Note: To select multiple items, press and hold the CTRL key while selecting items.
  2. Click the Move button.
    Note: To move all fields into the Selected Fields list, click the Move All button.
  3. To indicate the order in which the columns are to be sorted, select one or more items in the Selected Fields list and use the First, Up, Down, and Last buttons to adjust the sort order.
  4. If the report requires the data to be grouped by the values of the first sort field, select the Check here if you would like the report to add grouping levels to your report? checkbox.
    Note: The report will be broken into sections based on the first sort field selected.
  5. In the Ascend and Descend lists, select the sorting rule for each field
  6. Select the fields to be totaled, as applicable. Click here for instructions to select the fields to be totaled.

Tip

The sort criteria section is optional. You can leave this section blank when you create a report.

Tip

If you specify a grouping, the report will be broken into sections based on the first sort field selected.

Tip

If you specify a grouping and specify a total, a total line appears at the end of each grouping section. A total line appears at the end of the report for the entire report contents.

Tip

If you do not specify a grouping but specify a total, a total line appears at the end of the report for the entire report contents.

Tip

If you specify a grouping and specify a count, a count line appears at the end of each grouping section. A count line appears at the end of the report for the entire report contents.

Tip

If you do not specify a grouping but specify a count, a count line appears at the end of the report for the entire report contents.

Complete the Sort Criteria Section

  • How To
  • Step by Step

Complete the Sort Criteria Section

To complete the Sort Criteria section:

  1. Select the fields to be sorted.
    Note: To select multiple items, press and hold the CTRL key while selecting items.
  2. Click the Move button.
    Note: To move all fields into the Selected Fields list, click the Move All button.
  3. To indicate the order in which the columns are to be sorted, select one or more items in the Selected Fields list and use the First, Up, Down, and Last buttons to adjust the sort order.
  4. If the report requires the data to be grouped by the values of the first sort field, select the Check here if you would like the report to add grouping levels to your report? checkbox. 
    Note: The report will be broken into sections based on the first sort field selected.
  5. Select the sorting rule for each field.
  6. Select the fields to be totaled. Click here for instructions to select the fields to be totaled.

  • Complete the Printing Criteria Section
  • Complete the Report Definition Section
  • Complete the Selection Criteria Section
  • Complete the Total/Sum Criteria Section
  • Create, Modify, or Replicate a Report Definition
  • Create, Modify, or Replicate Report Page Overview

Tip

The sort criteria section is optional. You can leave this section blank when you create a report.

Tip

If you specify a grouping, the report will be broken into sections based on the first sort field selected.

Tip

If you specify a grouping and specify a total, a total line appears at the end of each grouping section. A total line appears at the end of the report for the entire report contents.

Tip

If you do not specify a grouping but specify a total, a total line appears at the end of the report for the entire report contents.

Tip

If you specify a grouping and specify a count, a count line appears at the end of each grouping section. A count line appears at the end of the report for the entire report contents.

Tip

If you do not specify a grouping but specify a count, a count line appears at the end of the report for the entire report contents.

Select the Report Fields to be Sorted

Report Writer select field

To select the report fields to be sorted:

  1. From the Available Sortable Fields list, select the fields to be sorted.
    Note: To select multiple items, press and hold the CTRL key while selecting items.
  2. Click the Move button.
    Note: To move all fields into the Selected Fields list, click the Move All button.
  3. To indicate the order in which the columns are to be sorted, select one or more items in the Selected Fields list and use the First, Up, Down, and Last buttons to adjust the sort order.
  4. If the report requires the data to be grouped by the values of the first sort field, select the Check here if you would like the report to add grouping levels to your report? checkbox.
    Note: The report will be broken into sections based on the first sort field selected.
  5. In the Ascend and Descend lists, select the sorting rule for each field
  6. Select the fields to be totaled, as applicable. Click here for instructions to select the fields to be totaled.

Tip

The sort criteria section is optional. You can leave this section blank when you create a report.

Tip

If you specify a grouping, the report will be broken into sections based on the first sort field selected.

Tip

If you specify a grouping and specify a total, a total line appears at the end of each grouping section. A total line appears at the end of the report for the entire report contents.

Tip

If you do not specify a grouping but specify a total, a total line appears at the end of the report for the entire report contents.

Tip

If you specify a grouping and specify a count, a count line appears at the end of each grouping section. A count line appears at the end of the report for the entire report contents.

Tip

If you do not specify a grouping but specify a count, a count line appears at the end of the report for the entire report contents.

  • Back
  • Forward
  • Home
  • Help
  • Print document