Sorting.

[Prakash Bhai]

Hi All,

I have a column called Month. And in that I have the months starting from April,December,February... and so on In Ascending Order. When I just run the report it shows April 1st and then March. If I change the sorting in to descending order. For time being it will be Ok. But at later stage's it shows March 1st and May then...  I guess we need to write a Case stmnt and then we need to assign some values.  If am correct pls guide me how to solve this..

Regards,
Ram.

[kattaviz]

Hi Ram,

If you have date field in your query then u can include that field and sort it by ascending and hide that column. If you don't have date field then you have to write a case statement based on month (January -1,February-2 etc) ,include this in layout,sort on this column and hide this column in layout.

HTH