set result in ascending order

[dr223]

Hallo,

I have the following formula which works fine. However, when I select ALL the records are not sorted in ascending order as per the drop down list (i.e., ?Practice). Is there a way I can display the records in alphabetic ascending order?

Thanks

(if {?Practice} = "ALL" then TRUE
else {GP27.PRACTICE} = {?Practice})

[jawadhashmi]

sort the record using sort expert. and define the sortign order.