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