Cognos 11.0.8 - Sorting in a report

[insight523]

Is there a way to sort by column heading in a report other than making it interactive?  Cognos 10.2.2 has the capability to sort by clicking on the column headings, but when upgrading those reports to 11.0.8, this functionality is not present.  Is there some way to turn sorting capabilities on? 

[Pratap Reddy]

Hi,

Click on Column Heading-->Go to Properties--->Allow Sorting ---->Yes for Active Reports

The Links may help you for dynamic sorting for Column Header in reports

https://www.youtube.com/watch?v=63a41CV6okI

https://www.youtube.com/watch?v=Fv_HAghWuLg


i hope this may helpful for you.

[insight523]

I think that is for version 10, which we have working ok.  It's in 11 that we are having the problem and I don't see that option. 

We have dynamic sorting capability by column in cross-tabs in our current version 10.2.2 where the user can sort by clicking on the column heading.  This is not converting into version 11.0.8 and our end users have lost the ability to sort.  Turning the reports to interactive mode will not work for us for various reasons.  Trying to find out if anyone else has experienced this or found a work around to allow dynamic sorting by column for the end user. 

[MFGF]

I think that is for version 10, which we have working ok.  It's in 11 that we are having the problem and I don't see that option. 

We have dynamic sorting capability by column in cross-tabs in our current version 10.2.2 where the user can sort by clicking on the column heading.  This is not converting into version 11.0.8 and our end users have lost the ability to sort.  Turning the reports to interactive mode will not work for us for various reasons.  Trying to find out if anyone else has experienced this or found a work around to allow dynamic sorting by column for the end user.

Hi,

Can you explain how you have implemented sorting by clicking on a column heading in your crosstab in 10.2.2? Can you explain what "This is not converting into version 11.0.8" means - in detail?

Cheers!

MF.

[Kiran P]

If you are talking about setting the value for  VIEWER_ENABLE_SORT to true in advanced configuration settings of dispatcher in 10.2.2 that was allowing sorting of values in list, pls understand that 11.x uses a different report viewer than 10.2.2. I think it still uses legacy viewer when a report is embedded using SDK into an application (remember reading it somewhere for 11.0.4 or 6 and not sure if it is true for 11.0.8) but otherwise interactive viewer is the only one available and since there is already a functionality to sort in interactive mode, this viewer do not support these advanced settings anymore.

Thanks,
Kiran