Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Incrementing Report Variable on change of Group
Message
De
27/03/2002 20:18:32
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australie
 
 
À
27/03/2002 19:37:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00638191
Message ID:
00638229
Vues:
25
Hi Steve,

I have a report variable called r_Transactions which has a 'Value to store:' of 1, a 'Calculate' of 'Sum' and is reset at change of account, this variable keeps track of the number of transactions for the account. I then have another report variable called r_Accounts which has a 'Value to store:' of 'IIF(r_Transactions = 1,1,0)', this means that the r_Accounts variable will be incremented by 1 only on the first transaction of each account. I then sum r_Accounts at the end of the report.

Regards,
Gavin...

>Gavin,
>
>How did you do it? I'll share my solution with you if you share yours with me :)
>
>>

PLEASE DISREGARD THIS MESSAGE. I'VE WORKED IT OUT !!!


>>
>>Hi All,
>>
>> I have a report which prints accounts and their associated transactions. I've grouped the report by account and print the account details in the group header. In the detail band I print all the associated transactions. At the end of the report I have a field that displays the total number of accounts that appeared on the report. The problem I've run into with using a report variable to accomplish this is that the report variable is incremented per detail line and I want it to only increment on change of group. I've tried using the ON ENTRY expression in the group header to increment my report variable by 1 but this doesn't work. Any ideas on how to accomplish this?
>>
>>Thanks,
>>Gavin...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform