How order a report by a total field

Leroy · 2009-04-15

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 · 2009-04-15

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

Leroy · 2009-04-15

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 · 2009-04-15

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 · 2009-04-15

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

How order a report by a total field

Comments

Categories