Eclipse Community Forums: BIRT » Dynamic Sorting on Derived Columns of Crosstabs

Home » Archived » BIRT » Dynamic Sorting on Derived Columns of Crosstabs

Dynamic Sorting on Derived Columns of Crosstabs [message #693483]

Wed, 06 July 2011 10:48

Eclipse User

Hi,

I'm trying to do dynamic sorting on crosstabs, where the users can specify which column they would like to order the rows based on .

I've read
http://birtworld.blo...-scripting.html
and
http://www.birt-exch...pt/#description

With the help of the above links, I can do dynamic sorting on aggregation columns with API. But for the Derived Columns , it seems does not work.

For example, amount of sales, amount of rent, and amount of tax are 3 aggregation columns of the crosstab, I can do sorting on any of them using API.
But now I have a derived column [amount of mystery income], whose expression is total([amount of sales]* [amount of rent] *[amount of tax]) / total([amount of rent]*[amount of tax]), is there someway to do dynamic sorting on this derived column please?

Thanks in advance.

[Updated on: Thu, 07 July 2011 10:46] by Moderator

Re: Dynamic Sorting on Derived Columns of Crosstabs [message #694004 is a reply to message #693483]

Thu, 07 July 2011 12:01