General information
Category:
Reports & Report designer
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...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only