Getting ready

Open the report created in the previous recipe in Cognos Report Studio for further amendments.

How to do it...

How it works...

The Sort option by default works at the detailed level. This means the non-grouped items are sorted by the specified criteria within their own groups.

Here we want to sort the product lines which are grouped (not detailed items). In order to sort the Groups, we need to define the advanced sorting option as shown in this recipe.

There's more...

You can define it so for the whole list report from the Advanced Sorting dialog box. You can use different items and ordering for different groups and details.

You can also choose to sort certain groups by the data items that are not shown in the report. You need only bring those items from Source (model) to the Query, and you will be able to pick it in the sorting dialog.