+ Post New Thread
Results 1 to 2 of 2
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 - ...
  1. #1

    Join Date
    Sep 2011
    Location
    Cardiff, UK
    Posts
    37
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    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?

  2. #2

    Join Date
    Oct 2005
    Posts
    62
    Thank Post
    7
    Thanked 20 Times in 17 Posts
    Rep Power
    22
    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.



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Sims Lesson / Attendance Report
    By IrritableTech in forum MIS Systems
    Replies: 10
    Last Post: 4th May 2012, 02:38 PM
  2. Online Reporting for September
    By Cache in forum CLEO
    Replies: 5
    Last Post: 12th October 2009, 08:55 PM
  3. SIMS Attendence reporting
    By Stuart_C in forum MIS Systems
    Replies: 6
    Last Post: 3rd March 2009, 12:16 PM
  4. Online reporting for parents
    By pooley in forum How do you do....it?
    Replies: 1
    Last Post: 19th May 2008, 01:15 PM
  5. Individual reports for students in SIMS
    By cjohnsonuk in forum MIS Systems
    Replies: 2
    Last Post: 25th March 2008, 12:27 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •