Is there anything other than ascending or descending on a Filter Sort
My filter values in a report are selected via a custom sql query, where I order values on an order by that is neither ascending nor descending. Again, its an order by I created as a way to sort values of the top 3 most used values.
Is there any way the filter box displayed in a report can honor the custom sort I've provided in my sql query?
I only have the option of Ascending or Descending...
I've tried reference codes, but I only need to make sure the top few values are listed first in the filter dialog, not the remainder of values seldom selected.