custom sort for report prompt/filter
I am using freehand SQL to build a set of prompt values within the "Format -> Entry Style" menu. I have the order by clause in my sql - it is a customized sort, not as simple as ASC or DESC on the field displayed. When I click "Test Query", the data returns in the order I want. However, right below the test query results box is a "Sort" option. It appears mandatory to use this, and the "Ascending" and "Descending" options both screw up the custom sort I used in my freehand SQL. Is there any way around this? I simply don't want to use the GUI's "sort" option when using freehand SQL to build prompt values.