Skip to Content

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

Mar 16, 2017 at 03:24 PM


avatar image

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


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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers