How do I sort rows in a report based on a non-sequential non-ascending or descending pre-defined order?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have created a table of team-members.  

I would like to display the report on each team with a hierarchy of roles for each team beginning with the sponsor at the top then chairperson, administrative assistant, improvement specialists, members, and ad-hoc participants following in that specific order.    I used to be able to do this by specifying the drop down list sort order.  Unfortunately the role names and descriptions are now in a separate look-up table.  Any suggestions are welcome.

Photo of Jon


  • 0 Points

Posted 3 years ago

  • 0
  • 1
No problem.

Make a new numeric field on the Role called Sort sequence.

I assume that you are looking up the Role Description, so also bring down the Sort Sequence, and then sort on it.