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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Wed, 06 July 2011 14:48

Scroon

Messages: 28
Registered: June 2011

Junior Member

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 14:46]

Report message to a moderator