MIS Systems Thread, Attendance Reports for date range in Technical; Hi I'm helping our attendance officer with a new report, although we know Sims produces many attendance reports itself - ...
11th October 2013, 01:47 PM #1
- Rep Power
Attendance Reports for date range
Hi I'm helping our attendance officer with a new report, although we know Sims produces many attendance reports itself - currently she is running a report for this week and manually typing it onto a sheet for every pupil to see a cumulative report per week.
I am trying to design a report to do all the hard work, in a similar way as i do for conduct.
I wish to display the attendance for a pupil over a date range, for example what there attendance was at end of week one, end of week two etc in separate columns.
I can do this for conduct by selecting the achievements/behaviours and filtering by date. However when i have tried to do this for attendance it only gives me the current attendance - i cant filter by date.
Is there a way to do this?
IDG Tech News
11th October 2013, 03:29 PM #2
When you create your report, you need to base it on Student, On Roll and then add the Attendance Marks subreport. From here, you can add the Mark and Mark Date. You then need to create a filter on the subreport by clicking the little red book icon on the right-hand side, then click New at the bottom and add the Mark date field. The key is to create the filter on the Attendance Marks subreport, not on the main report. This will give you a list of students attendance marks between the two dates, so it probably won't be in exactly the format you want. You'll probably need to bring it into Excel and do some group or summing or whatever to produce the weekly totals.
By IrritableTech in forum MIS Systems
Last Post: 4th May 2012, 02:38 PM
Last Post: 12th October 2009, 08:55 PM
By Stuart_C in forum MIS Systems
Last Post: 3rd March 2009, 12:16 PM
By pooley in forum How do you do....it?
Last Post: 19th May 2008, 01:15 PM
By cjohnsonuk in forum MIS Systems
Last Post: 25th March 2008, 12:27 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)