is there a way to have dynamic filtering on a list report in cognos where the user can sort it in different ways while viewing the report.
This can be achieved only via Active reports.
Quote from: maxchuie on 19 Mar 2014 08:48:16 AM
is there a way to have dynamic filtering on a list report in cognos where the user can sort it in different ways while viewing the report.
You mention filtering as well as sorting, so it isn't clear to me what your requirement is exactly. It is possible to include a prompt control on the report page that allows the user to make different selections in the Cognos viewer. It would further be possible to create a sort key that could differ based on what was selected in a prompt. There are also methods for changing the sort dynamically using a drill through back to the same report. There are also javascript methods for altering the sort, although I'm less a fan of those.
Active Reports would offer other options, but I don't think that is the only option available. If you clarify your requirements it would be easier to advise.