Laurence School [Helpdesk]

Custom Attendance Reports are available from Crystal Reports. The date values must be updated once per year.

Record Selection formula for all records

• Uses specific date ranges for K-5 and 6 since they are on different term schedules  

  (({RG_STUDENT.HOMEROOM} = "1A" or 
  {RG_STUDENT.HOMEROOM} = "1B" or 
  {RG_STUDENT.HOMEROOM} = "1C" or 
  {RG_STUDENT.HOMEROOM} = "2A" or 
  {RG_STUDENT.HOMEROOM} = "2B" or 
  {RG_STUDENT.HOMEROOM} = "2C" or 
  {RG_STUDENT.HOMEROOM} = "3A" or 
  {RG_STUDENT.HOMEROOM} = "3B" or 
  {RG_STUDENT.HOMEROOM} = "4A" or 
  {RG_STUDENT.HOMEROOM} = "4B" or 
  {RG_STUDENT.HOMEROOM} = "5A" or 
  {RG_STUDENT.HOMEROOM} = "5B" or
  {RG_STUDENT.HOMEROOM} = "KA" or 
  {RG_STUDENT.HOMEROOM} = "KB" or 
  {RG_STUDENT.HOMEROOM} = "KC") and 
  {ATTEND_DAY.ATTEND_DATE} >= DateTimeValue (2016, 04, 04, 00, 00, 00) and 
  {ATTEND_DAY.ATTEND_DATE} <= DateTimeValue (2016, 06, 09, 23, 00, 00) and 
  {RG_STUDENT.STUDENT_GROUP} = "Student" and 
  ({ATTEND_DAY.ATTEND_TYPE} = "Absent" or {ATTEND_DAY.ATTEND_TYPE} = "Tardy")) 
  or
  (({RG_STUDENT.HOMEROOM} = "6A" or {RG_STUDENT.HOMEROOM} = "6B") and 
  {ATTEND_DAY.ATTEND_DATE} >= DateTimeValue (2016, 01, 19, 00, 00, 00) and 
  {ATTEND_DAY.ATTEND_DATE} <= DateTimeValue (2016, 04, 16, 23, 00, 00) and 
  {RG_STUDENT.STUDENT_GROUP} = "Student" and 
  ({ATTEND_DAY.ATTEND_TYPE} = "Absent" or 
  {ATTEND_DAY.ATTEND_TYPE} = "Tardy"))