Skip to Content

Crystal Reports - How do I Show a label and a zero if count function is null?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers