Sorting by Calculated variable field

[2006 IR Open Dicussion]

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