Ask At Runtime Sorting

Foxfire! has a great ask at runtime feature for filters. But wouldn't it be great if you could also ask your users how they wanted the report sorted at runtime? This would allow you to build an initial report, give it to users and allow them to sort and filter it as they need to without changing the internal details or having to train them on the Request Editor.

Thanks to the FFCONFIG file, you can do this very easily. Here's how to implement this functionality, in any version of Foxfire! from 3.0 to 6.02:

In the BEFORE SQL GENERATION phase of the FFCONFIG, add the following lines:

ED_LOCK=.T.
DO FFREQSRT

That's it! Now when your users run the request, they will be prompted with the Sort dialog so they can choose the desired sorting for their request.