Top N Reports

[VFXdbGuy]

I have a Work Order table that includes an operator field and I have a Work Order Items table that details work performed in a number of different areas (ie: prep, assembly, finishing, etc)

I'd like to have a report that lists the operators and all their work orders that is sorted by the total hours performed by each operator with the operator with the most hours being first in the report then the one with the second-most, etc. basic Top N reporting that a program like Crystal reports can do no sweat.

The basic report is simple, sorting by operator. But trying to find a way to maintain the grouping by operator but sort by work performed is a pain. Maybe it isn't possible?

[VFXdbGuy]

I got closer...

The report now sorts by total work order hours then by operator but this splits up operator records.

Anybody??

[VFXdbGuy]

So, I guess there is no way to do this...? Sad, huh?

I think this whole "you have to sort the data to see groupings in reports" is the single biggest weakness in FileMaker.

[-Queue-]

Try adding a calculation of GetSummary( sumhours; operator ), where sumhours is a summary field based on hours, and sort by this field, descending.