How do you keep more than one section together in a report ?

JJordan

Registered User.
Local time
Today, 07:32
Joined
Jul 25, 2002
Messages
53
Counting problem in a report.

Edit: Woops, I already answered the first question, (dopey me) I should probably repost this one but I also need to know:

I have a report with headers for ProgramID (the program the Family Attends); FamilyID Header (names of Families) and then in the Detail, I have Children. The report generated tells us every Family that has been in each "Program" and for each family lists their children.

I would like to count the total number of families and children that attend each Program, but a family (kids too) may particiapte in more than one program . I cannot figure out what to count. If I count familyID in the ProgramID Footer, it counts the total times that family has been in any program (if the same family is in program 1 and 5, the count is 2 for that family -- e.g., if family Jones is also in Program 6, the count for Program 1 above is 4 (1 for each of the first 2 familes and 2 for the Jones family) I must be counting the wrong thing.
 
Last edited:
Did you try grouping your report on the Program ID? Then when you select Program ID under grouping/sorting, you can choose to have a group header and footer. List the Program Name under the Group Header and use your counting in the Program Footer. I don't know if it will help with the whole question, but it should help to get you on the right track.
 

Users who are viewing this thread

Back
Top Bottom