PMFJI--I had an idea...

Could you do this this way:

1. Create report variables like RecnoOfGrpSalesman that resets on group salesman and is a count.
2. Create report variable salessum with the expression iif(RecnoOfGrpSaleman = 1, shipamt, 0) and set this one to sum.

That way, it only gets summed when the group changes.

HTH, if you would like, I could go into more detail!

>>I created a Sales Commission Report using VFP's Report Designer.
>>
>>It has 5 breaks (bands): salesman, date, order#, shipment#, detail line.
>>
>>I feed the report a single cursor which has loads of data at the detail level and some data (including numeric values) at the group (shipment#, order#) level.
>>
>>Some of the expressions I print in report footers are not sums of detail amounts but rather amounts that belong to break level data. F'r instance, the cursor has a column that is shipment amount and I display that for the first time in the shipment# footer band.
>>
>>It is easy enough to display this value at the Shipment# level, but when I go to SUM it for the next level, the Order# level, it is all screwed up, as it seems to add it up once for every detail line, not once per shipment, even though it is a figure that does not belong to the detail level.
>>
>>If I have been clear, what do I do to correctly calculate and display a SUM of non-detail numbers?
>>
>>David
>
>What is the Sums reset set to? ( In its calculate field modal dialog )
>
>Dan