Reporting question - can you designate grouping order? | Community
Skip to main content
Level 3
September 26, 2019
Question

Reporting question - can you designate grouping order?

  • September 26, 2019
  • 2 replies
  • 475 views
Good afternoon, I have created a report that I have group by program and then by status. But I want to dictate what order the statuses show up under the program. Such as Current, On Hold, Complete, Planning. Is there a way to set this? THank you, Kristina Kristina Walton Healthgrades
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Level 10
September 26, 2019
the statuses show up alphabetically according to their three-character key, as far as I know. So the only workaround would be to create statuses that alphabetize according to that, and mandate their usage. -skye
Level 2
September 30, 2019
You can't choose the sort within the Grouping tab, but whatever sorting you choose in the View tab will apply. I would first group by Program column and second by Status column, then choose what type of sorting you want to use for Status - though I believe you are restricted to Alphabetical (Ascending or Descending). Tina Craig Houghton Mifflin Harcourt Publishing Company