How order a report by a total field

Leroy

Hello, I've a report with two dataitems, Customer (as first dataitem) and "Item Ledger Entry", and there is a total field, on "Item ledger entry" footer trigger, that shows the sum from other two fields. I'd like to know if there is any way of order the report by this total field; now it order by Customer number.
Thanks in advance.

matttrax

You'd have to store it in an array or temp table and then sort on it.

Leroy

Thanks for reply. Sorry, I don't understand it, I never have done something like this. I suppose that that field I've to transform into a variable, but after that I don't know what to do.
Thanks for help.

Savatage

You can get a good example from::
Arrays..
Top_Customer List Report
Top_Inventory Items Report

Temp Table..
http://www.mibuso.com/howtoinfo.asp?FileID=6

Leroy

Ok; I'll take a look.
Thank you very much for help.