|
User Rights: Location: |
Selected Report -> Report Designer [New Design/ Modify Design] |
Sorting in reports is a very useful method for ordering data to make it easier to read. You may want to display Projects in order of Project Id or Date Started, display Resources in order of name or display Tasks in descending order of planned effort so the highest values are displayed first.
To sort on a column, you must select the Sort Check box during the Add Column or Modify Column process. The application will detect if the Column you are sorting on is a numeric or alpha-numeric field and sort your report accordingly.
If you mark more than one Column for sorting in your report, the Column that appears first in the Report Design will be the Column sorted first in your report.
Follow these steps to Group Columns in a Report Design:
See the Add Column or Modify Column process for opening the Add Columns or Edit Column pop-up screen.
Click on the Sort Check box.
Change the direction of the Sort from Ascending to Descending if required.
Click the Update Column button.
Click the Save Changes button when you return to Report Designer to ensure that you save the change you made to your report.