Print Page - Dynamic Sorting in the report output

Title: Dynamic Sorting in the report output
Post by: babu babu on 06 Dec 2010 12:45:18 PM

Hi,
How can i do dynamic sorting on the columns in the report output.

Thanks!
Anand.

Title: Re: Dynamic Sorting in the report output
Post by: lindero on 05 Jan 2011 09:19:09 AM

Hi,

want do you mean with "dynamic sorting"?

You are able to sort within a report result in Business Insight or an Active Report report. It still doesn't work in Cognos Viewer.

bye

Title: Re: Dynamic Sorting in the report output
Post by: Sune Jorgensen on 16 Feb 2011 06:21:25 AM

BSP Software has a webcast about how to make a dynamic sorting

http://www.bspsoftware.com/Support/PodcastChannel/tabid/228/Default.aspx

Webcast number 2.15

Cheers
Sune

Title: Re: Dynamic Sorting in the report output
Post by: Ramesh Sanka on 01 Apr 2011 06:22:40 AM

As of my understanding i am giving the answer. I am expecting i want to apply sorting based on the end user selected column. If the meaning is that then you can follow the below details.

Create report with static prompt in the static prompt values like pline,ptype,pname.

create a new dataitem with the following expression
case
when ?sort?-'pl' the product line
when ?sort?='pt' the product type
when ?sort?='pn' then product name
end.
drag the column before product line and hide the column.

Regards,
Ramesh Sanka

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: babu babu on 06 Dec 2010 12:45:18 PM