Hi Jeff
INDEX ON cStandard+cAudit_Type + transform(999-Number_of_Days)
Using SQL you can create a cursor ordered the way you need it and run the report against that. You can also let the user access this cursor instead of seeing the table itself.
>I have a customer that would like to have a report sorted the following way:
>
>cStandard c(30),cAudit_Type c(30), Number_of_Days Desc n(3,0)
>
>I can't seem to figure out how to do it. They would like the cStandard and cAudit_Type to be in ascending order but the Number_Of_Days to be in descending order within the audit type grouping. Is this possible?