Sort on Month Name

[barrysaab]

I need to sort Month_Name in Cross tab which is coming up now as Aug,Feb,Dec--,I want it to be like Jan,Feb,March--Dec.The sorting option is not working.Please help.Thanks

[blom0344]

Create an additional dataitem (using a Case expression) that adds an index to the name :  1.Jan  2. Feb  etc
Associate this with the crosstab header and use it for the underlying sort.

[barrysaab]

Thanks,blom0344.

[absriram]

Barry,

You can also use extract function to get the month number and use that as the sorting key.

Sriram.
http://www.cognosonsteroids.com

[barrysaab]

Sriram,could you please tell me how to extract the number,all i know we can extract month such as extract([Date],Month).Thanks