Navigation: Using Responsive Time Logger (topic list) >
Sorting & Subtotaling the Time Records
|Top Previous Next|
Sort on One Field:
To quickly sort the time records in the main window on one column (field), right-click on the column label at the top and select Sort Ascending or Sort Descending.
NOTE: Using the above feature will change the values in the Sort Order/Subtotals window (shown below).
Sort on One or More Fields with Subtotaling:
To sort the time record list on up to four different fields, in ascending or descending order, you use the Sort Order/Subtotals window (shown below). Using it you may:
Using the Sort Order / Subtotals Window
IMPORTANT: Note that if you want the records sorted by date and time, use Start rather than Start Date. Start includes both the Start Date and Start Time, while Start Date includes just the date.
NOTE: You can also quickly sort by one column when on the main window of Time Logger – just right-click on that column header and choose "Sort Ascending."
Subtotals - How to Use Them
TIP: When you work with Subtotals, change the order of the fields (between First Field, Second Field and Third Field) and select View/Subtotals each time to get a feel for how Subtotals work.
For the screen print of the Sort Order / Subtotals Window above, see an example of the View/Subtotals output here.
Examples of Sort Order / Subtotals
Result: The time records on the main window and if displayed on reports are in chronological order, oldest at the top and newest at the bottom. This is the Default setting.
Result: The newest time records will appear at the top and the oldest at the bottom on the main window and if displayed on reports.
Example 3: (shown above)
The main window displays the time records ordered by person in alphabetical order and for each person. Their time records within each person are displayed in ascending order by start date.
Saving Your Sort Order / Subtotals
You can save your Sort Order / Subtotals in an Environment file. You can give the Environment file a logical file name like: "Sort - Person Start Date.ev4" (you cannot use special characters in a file name).
Whenever you want to use your saved Sort Order / Subtotals, just select Tools/Load Environment: Sort - Person Start Date (Time Logger shows you an alphabetized list of the first 30 Environments on the Tools menu).
TIP: If you're only saving your Sort Order / Subtotals, be sure that only the Sorting/Subtotals checkbox is checked when you save your Environment file.
TIP: When you define a sort order that is different from the default, consider placing the column(s) that corresponds to the first, second, third, and/or forth sort fields to the left of all the other columns on the main window and then save an Environment with the Sorting/Subtotals and Appearance/Layout selected.
See Saving your Settings In Environments for more on this.