I want to keep values in ascending for one of the prompts.
I applied SORTING(asc) also, I took one NEW DATA ITEM in which i applied CAST function but still unable to sort the values in that particular prompt.
so wt shud I do
Pls help me guys asap!!
Thanks.
It will be very hard to hep you without understanding where you applied the sorting, and why did you have to cast the field, and what type data is it. For example, it could be that you casted numeric as text, in which case the order of values will be 1 10 11 12 13...19 2 20 21 etc - if we don't know, we can't help.
Also, there's no actual need to add "Pls help me guys asap!!'. It is obvious you're asking for help, the good people of this board will try to provide that (Free of charge) help when they can, even if this is very urgent for you. Also, not all of us are guys. Some of us are these magical not-guys creatures.