Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A Report Designer question
Message
 
To
16/07/1999 09:33:43
David Abraham
David Abraham & Associates, Inc.
New York City, New York, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00242272
Message ID:
00242656
Views:
20
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
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform