sorting and grouping

M

maryj

Client has a report with these fields - Sort Sequence (Num - Lng Int.), Tape
Type (Txt), Input ID (Txt), Mfg Order Nbr (Txt), Total Lnyd (Num - Lng Int)

He needs it to be grouped by Input Id to calculate the total Lnyd per Input
ID. But, he wants it sorted by the sequence number.

Seq.# Tape Type Input Mfg. Order Lnyd
20 9672 6780 MM33196 250
22 9672 6780 AA2323 360
Total of Total Lnyd

47 9480 3624 BB34834 900
48 9480 3624 CC334 900
Total

43 9472 5370 CC3434 360
44 9472 5370 DD3434 440
Total

50 9672 6780 BB545 480
52 9672 6780 CC3989 500
Total

The lines with the Sort Seq of 43 and 44 should be above number 47. This
will mean that the Input ID numbers will have more than 1 group.

He has identified in the Sorting/Grouping box, Sort Sequence listed first in
ascending order and then the Input ID field - with footer.
 
Top