Complex Sorting

[utsabsengupta]

i have a report which has column a
A has data A,B,C,LA1,LA2,LA3 IN ascending manner
but I want data to be in LA1,LA2,LA3,A,B,C
ie All LAs in ascending and then others in ascending

hw to do that?

[Sunchaser]

Hi,

If you have a first set of values ending with a number, and an order set without any number inside, we could imagine to do something like:

Code Select Expand


substr([VAL], length([VAL]), 1)

in a Expression of a Data Item of a Query Object.
In this test, [VAL] is the name I gave to the field with the datas ("a,b,c,la1,la2,la3").

If you order by the List on this new Data Item, you should have the good order.

Hope it could help
vinc.

[utsabsengupta]

Say I have a list report.I have two columns x and y.
I have a prompt (value prompt) for selecting a value for x and displaying the coressponding report.Now I want to dynamically sort the columns.Say if we click the header of x then x should be descending order and if we click header of y then y in descending.My report is running fine without the use of value prompt .But When I apply the prompt my report does'nt work.pLEASE help me out.