Using the Report Sort Order Section

As fields are selected during the creation of a report definition, they are added to the Available fields stack in the Report Order section of the definition in the order they are chosen.

The selected/accumulated fields (referred to here as ‘tiles’) can be placed in the Order by fields stack using either of the following methods:

Select a field by clicking on the tile (turning the tile darker), then click the right arrow.

Selected a field

After clicking the right arrow

Using can also use the drag and drop method. Select a field by moving the mouse cursor over the desired tile in the Available fields stack, press and hold the left mouse button, and, keeping the left mouse button pressed, drag the tile into the Order by fields stack, and then release the mouse button.

A field cannot be removed from either stack until the field is turned Off in each section (Field, Summary By, or the Detail Fields). Then, the associated field tile will automatically be removed from the stack.

The field tiles that appear in both the Available fields and the Order by fields stacks will be included in the report. The fields shown in the Order by fields stack will appear first in the report. Then, in the order, they appear in the stack. The top-most field tile on the Order by fields stack will be displayed as the left-most column in the report.

Any fields listed in the Available fields stack appear in the report in a pre-determined order, but they will appear after the fields listed in the Order by fields stack. For this reason, it is recommended to move all the fields listed in the Available fields stack to the Order by fields stack to ensure the correct order of appearance in the report.

Using the drag and drop method described earlier, tiles in either stack may be moved to a different position vertically within the same stack.

Return to Reporting Menu