Regarding Dynamic Sorting in Cognos 8.3

[dipstm]

Hi All,
I am using Cognos 8.3 in my project. I have a list report and want to sort the list report dynamically by clicking any one of headers of the list report. But the sorting should be performed on the whole query not only on the current list page displayed. I have got few support docs but those just dynamically sort the current list page.
   If anyone has something on this, plz let me know as I am trying this out from a long time.

Thanx in Advance

Regards,
Dipstm

[raro]

"Workaround":

- have different pages with same list but differently sorted per column
  e.g. if you have 5 columns in your list to be sorted, have 5 pages setting a different sort column on each page

- have a conditional layout variable selecting the page to be displayed
  e.g. variable=c1 .. will display a list sorted by column no.1 .. which is page1
  e.g. variable=c2 .. will display a list sorted by column no.2 .. which is page2
  and so on.

- on each page have a link setting the variable (e.g. constructing a URL-parameter)

let me know if this works for you.

[dipstm]

Hi raro,
I was trying ur workaround but its a more tedious task and in in addition to this, I want both ascending and descending sorting on column name of list report.
Is there any other way in Cognos 8.3 for dynamic sorting of list report which will sort the entire query and not only the current page of list report.
If anyone has tried dynamic Sorting plz share it as I am trying it out for quite a long time.

Thanx in advance,
Dipstm

[dipstm]

Hi All,
Is dynamic sorting possible in Cognos?
If yes, how it can be achieved?
If anyone has implemented dynamic sorting plz let me know.

Thanx in Advance...

[angela]

We don't have 8.3 yet, but there are techniques for this in 8.2 posted at http://it.toolbox.com/wiki/index.php/Category:Cognos8-l which might be of help.  I may have even seen some solutions in Cognoise - have you searched here for Dynamic Sorting?

[raro]

Querystudio allows dynamic sorting by default.

Did you try QS?

[raro]

We don't have 8.3 yet, but there are techniques for this in 8.2 posted at http://it.toolbox.com/wiki/index.php/Category:Cognos8-l which might be of help.  I may have even seen some solutions in Cognoise - have you searched here for Dynamic Sorting?

The idea behind is clever:

"... <queryitem>CASE ?SortColumn? WHEN 1 THEN [Retailer name]WHEN 2 THEN [Retailer type]WHEN 3 THEN [City]WHEN 4 THEN 'Number'ELSE END</queryitem> ..." + some javascript to pass the variable on to a cognos-url when clicking on a column header.