COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: biresg on 14 Feb 2012 09:28:30 AM

Title: Report Studio - Sorting Multiple Columns in List
Post by: biresg on 14 Feb 2012 09:28:30 AM
Hey all, simple question...

Have a list report, 3 columns, want to sort the first two columns.  You highlight the first column, sort ascending.
You highlight the second column to sort, but when you select ascending or descending, the first column sort goes away.

If I multi select both columns to sort at the same time, the sort icon grays out...  This is cognos 10 Report Studio.
I dont know If I am going crazy, but I always remember being able to sort on multiple columns...

Can someone please advise?
Title: Report Studio - Sorting Multiple Columns in List
Post by: MFGF on 14 Feb 2012 09:41:12 AM
Try grouping on the first column. When you sort the second, it should sort within the context of the groups in the first column.

Regards,

MF.


Sent from my iPad using Tapatalk
Title: Re: Report Studio - Sorting Multiple Columns in List
Post by: tjohnson3050 on 14 Feb 2012 08:38:06 PM
You can also select the entire list, then go to the sorting property in the properties list.  Then you can control the sorting across as many columns as you want.