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

Order of data

Started by knip, 29 Jul 2012 10:10:02 PM

Previous topic - Next topic

knip

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?

wyconian

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 :-)