General information
Title:
A Report Designer question
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only