Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Incrementing Report Variable on change of Group
Message
From
27/03/2002 20:18:32
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
 
 
To
27/03/2002 19:37:22
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00638191
Message ID:
00638229
Views:
24
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
Map
View

Click here to load this message in the networking platform