1. Create a report variable, rnCount. Set it to 0 and set the calculate option to SUM, and reset it at end of report.
2. In the OnExit expression of the customer data group footer, enter the following command: >>_VFP.SetVar(rnCount, rnCount + 1)
3. Use rnCount at the end of the report for the total number of unique customers.
>I now want the Counter Count = 2. Want to count the unique customers. I do have a customer band. I have tried a couple different things but can not get it to work. Tried varying your rnTotal to Count, and _VFP.SetVAr('rnTotal', rnTotal + 1), but no luck so far. Any Advice?
>
>thanks
>
>Brenda
>
>>- Create a report variable, rnTotal. Set it to 0 and set the calculate option to SUM, and reset it at end of report. (I know .. this sounds strange so far!)
>
>>- In the OnExit Expression of the Data Group Footer, enter the following line:
>
>>_VFP.SetVar('rnTotal', rnTotal + lineofcreditfield )
>
>
>>In the Report total, use the rnTotal variable -- no need to mark any special calculation options on it because you've already taken care of that.
>
>>>I have the following detail. Want the Total: to be 500,000 - not 1,000,000. I only want to add in the line of credit when the customer changes. Need to do it with variables, not with group footer. (the true report is just a bit more complicated. just trying to get to the basics)
>>>
>>>
>>>customer Line of Credit
>>>Henry 200,000
>>>Henry 200,000
>>>Robert 300,000
>>>Robert 300,000
>>>
>>>Total: 1,000,000
>>>
>>>Want - Total: 500,000