Sorting on Members

[Sarayucog]

Hi All,

I have list report and using DMR package. In list report how to apply sorting on a member.

I know how to apply from the tool bar. I want to know is there any other way to apply the sorting on the member.

Thanks in advance

[rockytopmark]

Use the order() function

[Sarayucog]

Thakns for your reply.

I forgot to inform you that I have tried with Order() and Hirarchize() functions also. These two functions are also not suitable to my scenario.

Please let me know if any other things you know.

[JGirl]

If you are using a 'Set Expression' in your query, you can specify set sorting (a property of the data item).

Your options are ascending, descending, hierarchized, and you can sort by a caption, a property (another data item such as an attribute), or a tuple.

[AussiePete2011]

Hi there

Check this document out
http://www.ibm.com/developerworks/data/library/cognos/page364.html

Also for dimensional reporting check out the available functions
http://www.ibm.com/developerworks/data/library/cognos/page82.html

Cheers
Peter B