Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a Group Counter
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01156251
Message ID:
01156357
Views:
16
>Thanks. That's an interesting solution. I tried it but I keep getting .F.! I added a new variable to the report and called it nUnSt (for Unique Student), then in the Student's group footer band I added "_vfp.SetVar([nUnSt], nUnSt = nUnSt + 1)" in the "On Exit" expression. Finally, I added a field in the Tutor's group footer to show nUnSt. When I run the report the value there is always .F. Any ideas?
>
>>There're a few ways to get it done. Check Re: Count Unique Customers in Footer Thread #1102497 for some ideas.
>>

It should be
vfp.SetVar([nUnSt], nUnSt + 1)
It can also be done with Report Variables. Try
Variable: rnLines
Value to Store = 0
Initial Value = 0
Calculation Type: Count
Reset At:Group: Student

Variable: rnUnSt
Value to Store = IIF(rnLines=1, 1,0)
Initial Value = 0
Calculation Type: Count
Reset At:Group: Tutor
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform