Information générale
Catégorie:
Gestionnaire de rapports & Rapports
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
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