I have a relational model. I have a DateTime field in which I'd like to pre-sort to be in Descending order in FM.
The reason: The data is being used in sort of a unique manner. When the users use this dateTime field and they filter on it in the report, they will only choose 1 date. Hence, a date range prompt for them in QUERY studio (they don't use RS) doesn't make sense as it gives the illusion that it's to be used. So I changed the Prompt info to be 'Select Value' in the model.
So far that works fine. They select a single date.
The enhancement: They would like the latest date to be at the top of the list when they go to filter. I was hoping there'd be an FM option to easily do this, but that's not the case.
But maybe someone can confirm?
Pinned topic FM Sorting fields - Relational model.
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-06T15:23:58Z at 2012-12-06T15:23:58Z by venkat_Jey