Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI everyone,
I hope you are doing well
can you tell me how i can change the display order of the labels please ?
thank you for your help
have a good day
Aubry M
Accepted Solutions
You can change the sort order using the "Sort" tab and Sort by Expression, e.g.
Pick(Match(Field,'A','B','C','D','E'),2,4,1,5,3) - this will sort the values in Field in the order C, A, E, B, D
You could also load the values in the order you want them displayed (using ORDER BY or other methods) and then uncheck all the boxes which will sort by the original load order, or you could assign a second field to each text field that will determine the sort order and use that in a dual() statement such as Dual(DisplayField,SortOrderField) as Field, in which case you can sort it numerically.
You can change the sort order using the "Sort" tab and Sort by Expression, e.g.
Pick(Match(Field,'A','B','C','D','E'),2,4,1,5,3) - this will sort the values in Field in the order C, A, E, B, D
You could also load the values in the order you want them displayed (using ORDER BY or other methods) and then uncheck all the boxes which will sort by the original load order, or you could assign a second field to each text field that will determine the sort order and use that in a dual() statement such as Dual(DisplayField,SortOrderField) as Field, in which case you can sort it numerically.
