Label is created with a formula field:
if (GroupName ({ATTENDANCE.YEARID}))={?Yearid for Freshmen Year} then "9" else if GroupName ({ATTENDANCE.YEARID})={?Yearid for Sophmore Year} then "10" else if GroupName ({ATTENDANCE.YEARID})={?Yearid for Junior Year} then "11" else if GroupName ({ATTENDANCE.YEARID})={?Yearid for Senior Year} then "12"
Then it counts up all the "absenses" on ATTENDANCE.ATTENDANCE_CODEID using
Count of ATTENDANCE.ATTENDANCE_CODEID
BUT...if a student has zero absenses, then I do not get anything. (since there are no records in the ATTENDANCE table.
Here is what I get: (I would like to see Grade 9 with a 0 under absent)
Grade Absent
10 2
11 1
12 5
Thank you in advance.