COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: div_1234 on 26 Aug 2011 01:50:20 PM

Title: custom order of column
Post by: div_1234 on 26 Aug 2011 01:50:20 PM
hi

i want to arrange column in specific order.

i created new data item

my expression r like


case[col]

when 'quantity' then 1
when 'sale' then 2
when 'min' then 3
when 'max' then 4

End

after that i click that query item and make that field to ascending order.

now the field r coming like 1 , 2 ,3, 4 in report,but i want  quantity,sale,min,max

how to do that?
Title: Re: custom order of column
Post by: MFGF on 30 Aug 2011 10:24:53 AM
Leave the original column in your list and sort it based on your new column. 

Regards,

MF.