Combing rows of data based on condition

[TJIT]

In the example below (in the Details section of my report), if the values in the first column, "order no." are the same in that section/group, there should only be one row instead of two and the "on hand Qty" should be combined equaling 3700 (3100 + 600) ...but only when the "order no." fields are equal.

order no.|item no.|req date|on hand Qty

release number 1
123-45 |PPP-01 |3-14-14 | 3100
123-45 |PPP-01 |3-14-14 | 600

release number 2
678-99 |PPP-01 |3-14-14 | 3100
679-00 |PPP-01 |3-14-14 | 600

Any ideas?

 

[AndyMc]

Create a group on Order No, sum the on hand Qty for the Order No group.
Copy the other fields into the Order No group footer, and suppress the detail section.

 

[TJIT]

I love you, man!