If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dynamic sorting

Started by yuvrz19, 21 Sep 2023 08:18:31 AM

Previous topic - Next topic

yuvrz19

Hi,
I am using cognos 10.
I have a requirement of grouping and sorting different columns. Out of 6 columns 4 are grouped and sorted. Now there is 5th column, which i need to sort based on given values not the usual ascending and descending sorting. I query i am achieving this via below.

......................
.............order by empName, case
when country = 'India' then 1
when country = 'America' then 2
when country = 'Bangladesh' then 3
end

So always i want the sort order as India first, America 2nd and Bangladesh 3.

I want to achieve similar on the 5th column on the report. Does anyone faced this kind of situation?