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?
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:
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.
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.