Thanks Barbara,

I may be close to doing what you suggest but that will involve major redesign so I'm still holding out for a Report Designer solution.

So,

More of (not quite) the same. Now that you folks have helped me calculate correct Order level values based on other than details (using a dummy = 1 or 0 as a multiplicand), now I have to display each salesman's total commissions for the day and each salesman's total commissions for the (period of the) report. An Order's commission does not exist until the Order band, and then it is the result of adding together 4 values that are all Order level variables, calculated with some difficulty. So how can I SUM(order_commission) so that it will display properly at day break and salesman break, rather than be calculated and accumulated for every detail record?

I am on the cusp of generating a (worse yet, perhaps more than one) cursor which will contain break-level calculated values, an idea that does not appeal to me for aesthetic reasons. It seems to me the Report Writer is the right place to calculate SUMs on the fly. Perhaps this is just a VFP Report Writer limitation, perhaps I am just not being creative enough.

Help!!!

David

++++++++++++++++++++++++++

>You may find it simpler to get these numbers outside the report using a second report cursor, then link your main cursor with the subtotals cursor with one record for each Shipment group for the report.
>
>Barbara
>
>>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