Dynamic Sorting in the report output

[babu babu]

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

Thanks!
Anand.

[lindero]

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

[Sune Jorgensen]

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

[Ramesh Sanka]

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