Jump to content
Changes to the Jaspersoft community edition download ×

Sorting by Calculated variable field


Recommended Posts

By: Neil H - neilhay

Sorting by Calculated variable field

2002-12-13 05:54

is there anyway to sort a report by variable?

 

I have variable expression which calculate sum and i want to sort that in Desc order.

 

Also i want a number 1 - #of records to show the ranking.

 

 

 

 

By: Teodor Danciu - teodord

RE: Sorting by Calculated variable field

2002-12-13 05:57

 

Hi,

 

No, it's not possible.

In fact, the engine never takes care of sorting.

Is for the data source to sort or be sorted before

being used by the engine.

 

Thank you,

Teodor

 

 

 

 

 

By: Neil H - neilhay

RE: Sorting by Calculated variable field

2002-12-13 06:09

any work around?

 

 

 

 

By: Teodor Danciu - teodord

RE: Sorting by Calculated variable field

2002-12-16 05:15

 

Hi,

 

If you get your data from a database,

your SQL queries could be enhanced so that they

also produce calculated values (totals and so on...).

And you could apply the ORDER BY clause to

these calculated columns in the query result.

 

I hope this helps.

Teodor

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...