Sorting Query Item in FM - Data in DESC order

[Brandimore]

Hi Folks

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?

Thanks!

[adik]

you can sort only when building a DMR, on strictly relational models you cannot sort.
wouldn't sorting from RS be an option?