Daily Attendance Report

Overview:  This report shows daily attendance information for the student body based on a date range.  Could be run for one day or several days.  The output includes attendace codes, time in and out, and comments.

Using sql is the only way to get attendance comments on reports, so this report and other on this site are useful if you want users to see the comments.  If you'd rather see the code description rather than just the abbreviation (Absent rather than A), change the ac.att_code part in the select in the sql to ac.description.

Input screenshot

Output screenshot

Code to Copy and Import into sqlReports:

<ReportName>Daily Attendance Report</ReportName>
<ReportTitle>Daily Attendance Report</ReportTitle>
<AfterTitle></AfterTitle>
<ReportGroup>Attendance</ReportGroup>
<ReportDescription>Report to show daily attendance information for a specific date range.</ReportDescription>
<SQLQuery>SELECT s.dcid, to_char(att.att_date,'MM/DD/YYYY'), s.lastfirst, s.grade_level, ac.att_code, att.att_comment, case when attt.time_in is null then '0' else regexp_replace(to_char(to_date(attt.time_in,'SSSSS'),'HH.MI AM'),'\.',chr(58)) end timein, case when attt.time_out is null then '0' else regexp_replace(to_char(to_date(attt.time_out,'SSSSS'),'HH.MI AM'),'\.',chr(58)) end timeout, attt.atttm_comment

FROM attendance att 
      INNER JOIN students s on att.studentid = s.id
	INNER JOIN attendance_code ac ON att.attendance_codeid = ac.ID
	left outer JOIN attendance_time attt on attt.attendanceid = att.id

WHERE att.schoolid = ~(curschoolid)
 	AND att.att_date between '%param1%'  and  '%param2%'
 	AND att.att_mode_code = 'ATT_ModeDaily'
	AND ac.att_code is not null

ORDER BY att.att_date, s.lastfirst</SQLQuery>
<ReportHeader><th class="DCID">DCID</th><th>Att Date</th><th>Student</th><th>Grade Level</th><th>Att Code</th><th>Att Comment</th><th>Time In</th><th>Time Out</th><th>Time Comment</th></ReportHeader>
<CreateStudentSelection>0</CreateStudentSelection>
<StudentSelectionQuery></StudentSelectionQuery>
<CreateStudentSelectionB></CreateStudentSelectionB>
<IncludeRowNumber>0</IncludeRowNumber>
<OpeninNewWindow>0</OpeninNewWindow>
<HideCopyButton></HideCopyButton>
<HideCSVButton></HideCSVButton>
<HideTabButton></HideTabButton>
<HidePDFButton></HidePDFButton>
<ShowSearchBox>1</ShowSearchBox>
<ShowResultsInfo></ShowResultsInfo>
<ParameterName1>Start Date</ParameterName1>
<ParameterVal1></ParameterVal1>
<ParameterCal1>1</ParameterCal1>
<ParameterOpt1></ParameterOpt1>
<ParameterName2>End Date</ParameterName2>
<ParameterVal2></ParameterVal2>
<ParameterCal2>1</ParameterCal2>
<ParameterOpt2></ParameterOpt2>
<ParameterName3></ParameterName3>
<ParameterVal3></ParameterVal3>
<ParameterCal3></ParameterCal3>
<ParameterOpt3></ParameterOpt3>
<ParameterName4></ParameterName4>
<ParameterVal4></ParameterVal4>
<ParameterCal4></ParameterCal4>
<ParameterOpt4></ParameterOpt4>
<ParameterName5></ParameterName5>
<ParameterVal5></ParameterVal5>
<ParameterCal5></ParameterCal5>
<ParameterOpt5></ParameterOpt5>
<PdfOrientation></PdfOrientation>
<NoCSVQuotes></NoCSVQuotes>
<NoRowSel></NoRowSel>
<ShowSHC></ShowSHC>
<UseColRe></UseColRe>
<UseFixHdr></UseFixHdr>
<HidePrint></HidePrint>
<ReportNotes></ReportNotes>
<UseColFilt></UseColFilt>
<UseRowGroups></UseRowGroups>
<UseRowGroupsOptions></UseRowGroupsOptions>
<DisplayRowGroupsCol></DisplayRowGroupsCol>
<UseRowGroupsCounts></UseRowGroupsCounts>
<sqlChartsReport></sqlChartsReport>

  Back to Attendance Reports Page