Ascending order (1 Viewer)

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})

HI
if i am not wrong you want "ALL" to be shown first and rest of the values sorted right ?

if that is the case provide some special characters to the string "-- ALL --" this will be placed first and rest of the values are sorted accordingly.