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.
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