>How do I make just one of the elements of a tag sort in reverse. What about the same for SQL. I am trying to sort a report in reverse Date order, then Alphabetically (fwd) within those dates.
>
>Thanks, Randy


you can reverse a numeric subexp easily

Assuming VARTYPE(exp2)='N'

INDEX ON fnToString(exp1)+fnToString(exp2)+fnToString(exp3) TAG TASC

* DESCENDING exp2
INDEX ON fnToString(exp1)+fnToString(fixedOffset-exp2)+fnToString(exp3) TAG TASC

* DESCENDING exp1,exp3
INDEX ON fnToString(exp1)+fnToString(fixedOffset-exp2)+fnToString(exp3) TAG TASC DESC

Assuming
VARTYPE(exp1)='C'
VARTYPE(exp2)='C'
COLLATE MACHINE
ASCII 0h0 not used

INDEX ON exp1+exp2 TAG TASC

#DEFINE REVERSE_ASCII 0hFFFEFD && ... 01

* DESCENDING exp2
INDEX ON exp1+SYS(15,REVERSE_ASCII,exp2) TAG TASC