COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: knip on 29 Jul 2012 10:10:02 PM

Title: Order of data
Post by: knip on 29 Jul 2012 10:10:02 PM
Hi Experts
                I have grouped my data based on a column in my list report now i want to display the records in the order i want rather than in aphabetical order how can i achieve this?
Title: Re: Order of data
Post by: wyconian on 30 Jul 2012 02:25:28 AM
Hi

Sorts can either be alphabetic, numeric or alhpanumeric.  So you need to create another item in the query which has the order of items you want to have, depending on how many items you have you could use a decode or case when statement to assign the correct 'sort value' to the correct item.  Then you can sort on the new column.

Good luck :-)