COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Ann on 01 Jul 2011 04:45:45 AM

Title: Dynamic sorting
Post by: Ann on 01 Jul 2011 04:45:45 AM
Hi Guys,

I have come across a new requirement. This is to implement dynamic sorting. Suppose we have a list. every time you click the column title, the list should be sorted on that particular column.

any clues??
Title: Re: Dynamic sorting
Post by: Lynn on 01 Jul 2011 07:44:55 AM
Attached is something I wrote up on a technique to do this using drill through back to the same report. Someone else quite clever came up with the idea so I can't claim credit for the approach.

If you search the forum for "dynamic sort" you'll find tons of posts on this topic. There are other java script approaches I believe, but I prefer to avoid JS.

Good luck!
Title: Re: Dynamic sorting
Post by: jeemalif on 13 Jul 2011 11:10:47 AM
We did something similar a long time ago, which I don't claim to be very easy either, but gives another option.

--Javed