Select Custom Report Columns to Sort on (Advanced)

When creating a custom report you can specify the order in which the results are sorted. You can sort the results on one or more columns, taken in any order, but results are always sorted in ascending order. To configure a report's sort order, you select the columns to sort on and then specify the sequence in which those columns are sorted. For example, you might sort on Module ID and then User ID to sort the results by course and then, for each course, the participants.

To select the columns to sort on

1. In the Report Wizard, click Advanced. Additional steps are shown in the wizard's navigation bar.
2. Click Sorting. The tables you can sort on are listed.
3. Select the check boxes of the tables you want to sort on.
4. Enter the order in which the columns are used to sort the results. Enter 1 for the highest priority, 2 for the next highest and so on.
5. Click Save.

Additional Information

Create a Custom Report

Select Custom Report Columns

Select Custom Report Grouping Information

Select Custom Report Column Order

Select Custom Report Column Filters

Select Optional Tables for Custom Reports (Advanced)

Edit Custom Report SQL Selection Criteria (Advanced)

About Custom Reports