General information
Category:
Reports & Report designer
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
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