Print Page - Sort By Date in a logic order ???

Title: Sort By Date in a logic order ???
Post by: newyork66 on 29 Jul 2008 09:02:09 AM

I have a database column is month (months as 3-char abbrevs, the data looks like ' NOV' ,'JAN', 'OCT' ....) in Cognos report studio how can I sort by those months so it can be displayed by a logical order like Jan, Feb, March, Apr...ect order it logically?

Title: Re: Sort By Date in a logic order ???
Post by: phanicrn on 29 Jul 2008 12:16:05 PM

write a case statement

case month= jan then 1
month=feb then 2
else ('')
end

sort by this column, or do advance sorting, it will work..

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: newyork66 on 29 Jul 2008 09:02:09 AM