Count subtotal bands in a VFP 9 report
Posted on 2011-09-26
Is there a way to get the number of subtotal bands in a Foxpro report?
In my specific instance, I need to find out how many distinct families a teacher as well as how many children she has, where there may be more than one child from each family being served by the same teacher...
I'm trying to get my data prepared as follows; the question is - how can I get a count of the number of families served by the teacher.
CLOSE TABLES all
SET SAFETY OFF
SELECT * FROM cases,teacher WHERE cases.cidinte = teacher.cidinte AND status = "A" ORDER BY fullname INTO table SYS(2023)+"\inter_case"
USE children ORDER cidchil
USE family ORDER cidfami
SET RELATION TO cidchil INTO children
SET RELATION TO cidfami INTO family
INDEX on fullname + family.familyname + children.fname TO SYS(2023)+"\inter_case"
BROWSE FIELDS inter_case.fullname,family.familyname,children.fname,children.lname,inter_case.date_assig