Sorting on calculated control in header?

L

LJones

Hello,
My report has a list of parts and their quantity & cost in
the detail section (not visible in this report). In the
Part Header section, I have used calculated controls to
sum the quantities and costs so that each part # is listed
only once with its totals.

I now want to sort these part numbers by their summed
costs. How do I do this?

Example: report now shows:
Part Total Qty Total Cost
AA 5 100
BB 10 250
CC 20 80

I want it to show CC first, AA second, and BB third.
Specifying sort on "Part" in Sorting & Grouping only sorts
by Part Number.

Thanks,
LJ
 
F

Fons Ponsioen

I have approached this a in some of my reports by
including the summed total in the underlying query, than
I would sort the report on this summed total.
Hope this helps.
Fons
 
Top