Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Andrus Moor,
Thank you so much for your splendid idea. I was beginning to go in that direction (what was left after all?) but you saved me MANY hours, so thank you very much.
My routine is called AM_total, in recognition of its source.
David
++++++++++++++++++++++++++++++++
>>I created a Sales Commission Report using VFP's Report Designer.
>>
>>It has 5 breaks (bands), major to minor: salesman, date, order#, shipment#, detail line.
>>
>>I feed the report a single cursor (not a requirement, just seems to be the way to do it) 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 a shipment amount and I display that for the first time in the shipment# footer band.
>>
>>It is easy enough to display this 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?
>
>1. Add a variable named r_Sum to report/variables:
> Initital value 0
> Value to store 0
> Calculate Sum
> Reset at End of report
>
>2. In group footer, add a field and use
> total( , 'r_sum' )
>
>
>func TOTAL
>PARAMETER subTot, prmVARIABLE
>store eval(m.prmVARIABLE) + m.subTot to (m.prmVARIABLE)
>RETURN ''
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement