Changing the Sorting on a duplicated report
The default sort orders will be copied to the report based on the type. Multiple sort orders are supported. An example is first sort by part number then by Item ID. Add additional sub-sorts, change the existing sort order, or remove a sort order.
Sorts can potentially be grouped on the report. Changing the sort order impacts the grouping on the report. Review the Layout before making changes to the Sorting to be aware of any consequences.
To modify the sort order on a duplicated report,
- Edit the report if it is not already in Report Edit mode by highlighting the report name and clicking .
- Click the Sorting tab.
- Make the desired changes to the sort order:
- To change a sort order field to a different sort order field, click the arrow in the list box to the right of Sort By or Then By and select the replacement sort order field.
- To add a sub-sort to the existing sort orders,
- Click to the right of Add Sort Column.
- Click the arrow in the list box to the right of Sort By or Then By and select the sort order field.
- Set the order of Ascending (smallest to largest, oldest to newest) or Descending (largest to smallest, newest to oldest).
- To remove a sort order, click to the right of the row.
- To inverse the order for a field, switch between Ascending (smallest to largest, oldest to newest) and Descending (largest to smallest, newest to oldest).
- To insert a sort order above one or more existing sort orders,
- Add a sort order to the bottom of the existing sort orders by clicking to the right of Add Sort Column.
- Set the new sort order to the same value as the one above by clicking the arrow in the list box and selecting the sort order field. Set Ascending or Descending based on the row above.
- Repeat step ii until existing sort orders have been moved down up to the point where the new sort order will be inserted.
- Click the arrow in the list box to the right of Sort By or Then By and select the sort order field then set the order to Ascending or Descending as required.
- Click to save the changes to the report.
Proceed to make the desired changes on the other tabs: Filtering, or Layout.
See also:
- Duplicating a Report
- Modifying the Columns on a duplicated report
- Customizing the Filtering on a duplicated report
- Editing the Layout of a duplicated report
- About Customizing Reports
- About Reports
- Running Reports
Copyright © 2020-2024 ToolHound Inc. All Rights Reserved.