Fixes for Student Batch-Wise Attendance report and Absent Student Report
diff --git a/erpnext/schools/report/absent_student_report/absent_student_report.py b/erpnext/schools/report/absent_student_report/absent_student_report.py
index a138ca6..82a20aa 100644
--- a/erpnext/schools/report/absent_student_report/absent_student_report.py
+++ b/erpnext/schools/report/absent_student_report/absent_student_report.py
@@ -49,7 +49,7 @@
def get_absent_students(date):
absent_students = frappe.db.sql("""select student, student_name, student_batch from `tabStudent Attendance`
- where docstatus = 1 and date = %s order by student_batch, student_name""", date, as_dict=1)
+ where docstatus = 1 and status="Absent" and date = %s order by student_batch, student_name""", date, as_dict=1)
return absent_students
def get_leave_applications(date):