COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ccbarbeau on 14 Jun 2016 01:29:04 PM

Title: Solved: Report automatically sorts on grouped column
Post by: ccbarbeau on 14 Jun 2016 01:29:04 PM
Hello,

In RS 10.2.2, I have a report with a sort on a timestamp. When I group another column, it overrides the timestamp sort and sorts the grouped column ascending. Any way to go around this? I don't remember this behaviour in 10.1.1...
Title: Re: Report automatically sorts on grouped column
Post by: HalfBloodPrince on 15 Jun 2016 01:06:35 AM
select column and click edit sorting layout . under group you will see columns on which have groups. Add column in order in which you want sort to happen under sort list
Title: Re: Report automatically sorts on grouped column
Post by: ccbarbeau on 15 Jun 2016 07:26:13 AM
Thank you. I had tried that before but found this morning that I had to bring the column I wanted sorted to the top of the groupings in the Edit Sorting Layout screen. It worked, problem solved! Thanks again.