Advanced Sorting in Report Studio

Usually if we have data(Reinsurer Name) with Upper and Lower case mixed then Cognos will sort in a different manner

If suppose we want Reinsurer Name to be sorted in proper way and not in the way the cognos does then we can use the below technique

1. Add new query item named Reinsurer Sort and have it has upper(Reinsurance Name) or lower(Reinsurer Name)
2. Select the List and Use this Query item in advanced 

-----------------------------------------------------------------------

how to create customized sort data items. In the example below, Classification is sorted in the preferred manner - by classification, not alphabetically.

Use case statement and assign numbers to static values to be sorted in a new query item 

Use this new query item for sorting

-----------------------------------------------------------------------------------