Dynamic Sorting by column header in list report

[sophiadevi]

Hi All,

I am looking for achieving dynamic sorting of multiple columns on click of list column headers(multiple data types-datetime,integer,varchar).
It would be of great help if someone could share the xml code for cognos 10, if available.

Thanks in advance.

[Grim]

Dynamic sorting of a list...
http://www.ibm.com/developerworks/data/library/cognos/reporting/scripting_techniques/page515.html

[sophiadevi]

Hi Grim,

Thanks.
Are there any other options by which you can achieve the same without modifying server files?

Thanks.

[Grim]

Hi Grim,

Thanks.
Are there any other options by which you can achieve the same without modifying server files?

Thanks.

Might be able to use this javascript way...YMMV
https://www-304.ibm.com/support/docview.wss?uid=swg21343332

[Lynn]

Or use drill through:

http://www-01.ibm.com/support/docview.wss?uid=swg21397882

[Michael75]

The more, the merrier, so, to add to Lynn's suggestion, here's another (rather old) drill through technique.

Haven't tried it myself, just found it in my archives. Attachment rather than URL because the latter is (was):

http://support.cognos.com/supported/supportlink/techniques/ta_0706_03.html

[navissar]

I'll pile one more. If you're on 10.2.1 FP1 and up:
http://www.linkedin.com/groups/Want-Dynamic-Sorting-in-Cognos-136893.S.5808065738367315968

[sophiadevi]

Hi Everyone,

Thanks a lot for u'r guidance.
I tried and have successfully implemented it via drill through technique.

Thanks.

[sophiadevi]

Hi All,

After implementing above drill through logic, I see that the list data is sorted desc when first clicked on. changes to asc on re-click.
Can you please help me getting the data sorted out other way round. (1st click- asc, 2nd click-desc).

I think it should be a small change , but seeking your help for the above.

Thanks