Sort Order

[jbruno]

Is it possible to choose a specific sort order, rather than simply ascending/descending?

 

[Chris RR]

Like what, for example?

It's not unusual in many systems, to build some sort of field that is used exclusively for sorting (and never seen by the user). For example, you might group left-handed, color-blind employees from Michigan as the group "A", contract employees from Iowa with red trucks as group "B", the rest of the world as "Z", then sort the resulting group codes. Go wild.

 

[jbruno]

I understand your point. Thank you. I was simply curious if I could decide to group/sort in a report in an order of my choice rather than ascending or decending based on a field. Can you type in the sort order somewhere?

 

[Pat Hartman]

You'll need to keep a table with the associations or add the sort key field to each record. For example. If I want a list of fruit in order by my favorites -

SortKey Fruit
1       Mango
2       Strawberry
3       Pineapple
4       Blueberry

If you keep the SortKey in a separate table, you will need to include that table in your queries to obtain the SortKey so you can sort by it.