Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Dynamic Sorting on Derived Columns of Crosstabs
Dynamic Sorting on Derived Columns of Crosstabs [message #693483] Wed, 06 July 2011 10:48 Go to next message
Scroon  is currently offline 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 10:46]

Report message to a moderator

Re: Dynamic Sorting on Derived Columns of Crosstabs [message #694004 is a reply to message #693483] Thu, 07 July 2011 12:01 Go to previous messageGo to next message
Scroon  is currently offline Scroon
Messages: 28
Registered: June 2011
Junior Member
I resolved the problem by finding the correct name of the derived columns from XML source other than the property window in BIRT designer.

[Updated on: Thu, 07 July 2011 16:00]

Report message to a moderator

Re: Dynamic Sorting on Derived Columns of Crosstabs [message #694063 is a reply to message #694004] Thu, 07 July 2011 14:06 Go to previous messageGo to next message
Scroon  is currently offline Scroon
Messages: 28
Registered: June 2011
Junior Member
Thanks anyway:D

[Updated on: Thu, 07 July 2011 16:00]

Report message to a moderator

Re: Dynamic Sorting on Derived Columns of Crosstabs [message #694425 is a reply to message #694063] Fri, 08 July 2011 10:42 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

How did you resolve this?

Jason

On 7/7/2011 2:06 PM, Scroon wrote:
> I resolved the problem, thanks anyway:D
Previous Topic:Data reduction
Next Topic:How to use scriptContext class in Birt engine 2.6.1
Goto Forum:
  


Current Time: Fri Aug 29 22:38:43 EDT 2014

Powered by FUDForum. Page generated in 0.01696 seconds