Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Summary vs group footer
Message
De
24/07/2007 19:56:22
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01243318
Message ID:
01243351
Vues:
27
>>>- Create a report variable called rnEmployees, set the Calculate option to SUM, and set the expression to 0 (Yes, zero).
>>>
>>>- In the OnExit Expression of the data group footer band, put the following expression: _VFP.SetVar('rnEmployees', rnEmployees + Table.NoOfEmpField)
>>>
>>>- In the Report Summary band, use rnEmployees to print the total employees.
>>>
>>>
>>>In case you're wondering, there's a reason I said the Group "Footer" and not the "Header". If you reprint the header when it overflows, you'd end up getting extra hits to your sum.
>>
>>Thanks Cathy, this seems to work and I sort of actually understand it. Is it true that you can only run one command in the OnExit Expression? What would you do if you needed to deal with more than one variable?
>
>See Re: Form Feeds in report designer Thread #669987 Message #671003
>
>E.g. NVL(_VFP.SetVar(...),'') + NVL(_VFP.SetVar(..),'') to set two variables.
>
>After I re-read your original question I see that I tried to put more into it when you actually asked for.

THanks Naomi
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform