Sorting in Selection Criteria

[Former Member]

Hello All,

I have "Key" and "Text" displayed in the selection criteria of a variable. by default this is sorted on "Key" while my user wants it to be sorted on "text". is there anyway to set it to be sorted on "text" and not on "Key".

Thanks

Akshat

[ccc_ccc]

Hi Akshaat jain,

Take the properties of characteristic which you want, in properties window you can see <b>"Sort Order"</b> by default it will uncheck, now u check it immediately another 2 list will be displayed there u can selecct Either <b>TEXT</b> or <b>KEY</b> in first list box and in second list box select either <b>"ASCENDING"</b> or <b>"DESCENDING"</b> ok

Pls assigan poins, dont' forget,

Regs

ANR<b></b>

[Former Member]

Hi Akshat

what u can do is .. in the global definition of the query go to properties of the required charecteristic change the display and down on left there is a sort option.u can change in there to get ur work done

hope this will help u to sort thngs out

all the best

Godhuli

[Former Member]

Hello Godhuli,

Thanks for the reply, actually that sorting option change the sorting order in the result (i.e on the grid which is displayed when query is actually executed).

My question was when i have some selection criteria for some variables in a report and on the first screen a list of all those variables appear where i can select or write down the filter values. there i have the option to click so a new small window popsup which shows me the some possible values of that variable and i select from that (based in =,[],* etc....). I want value in that Pop Up window to be sorted on text and by default those values are sorted on "Keys"[ and even in my query properties-> Display options, i have only selected to show "text" and to sort on that in ascending order] so it seems that those options are not governing what i want to change.

Thanks in advance for your help.

Regards

Akshat

[Former Member]

Hi Akshat,

I am having an issue exactly as yours for the selection value sorting. If you have found a solution for the same can you please post it?

Regards,

Rao