>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--