Sort off of a calcultated field

[GCL2007]

I have a report which totals Loss $ by item. The Loss $'s are calculated in a subreport and passed to the main report

In the main report, I use the below formula:
WHILEPRINTINGRECORDS;
NUMBERVAR LOSS_ITEM;

All is good with this - however, now I want to do a descending sort off this field to print the items with the greatest loss $ in descending order. Can't seem to make it work and was looking for an idea or two... Thanks

 

[lbass]

I'm assuming you meant:

shared numbervar loss_item.

You can't sort on a shared variable. Sorry.

-LB