Sorting by Calculated variable field

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