+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Attendance Report in Technical; Hi, I'm new to report making on SIMS and stuck with one stage of a report. I would like to ...
  1. #1

    Join Date
    Dec 2012
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Attendance Report

    Hi,

    I'm new to report making on SIMS and stuck with one stage of a report.

    I would like to make a report that lists the UPN's of pupils with 100% attendance between two given dates. I am stuck when it comes to setting date parameters.
    So far I have:

    Focus: Student
    Fields: UPN, Forename and Surname, % Present
    Filter: Present = 10%

    The only date option I can find is the one at the end giving me the option to set an individual date?

    Thanks.

  2. #2
    RCowderoy's Avatar
    Join Date
    Nov 2012
    Location
    London
    Posts
    8
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    If you run a lesson monitor report you can set the parameter such as date and % although you only get list of name and not UPN

    Select Reports | Lesson Monitor | Selected Student Reports |
    Percentage Attendance Report to display the Percentage Attendance browser.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,968
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    If you're just using the basic section for attendance summary, that will default to the year.
    You'd need to add the sub-table for attendance then filter that section for marks = '/' and mark date between x and y. If you add no fields from the sub-table it will do a count of them, and then you will have to know what 100% would equate to, i.e. 10 per week for 4 weeks, so you're looking for anyone with a 40 count.
    It's not pretty.

  4. #4
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    one of the things I would love to see is to have some access to the pre-built lesson monitor reports to add in fields I'd like (or our attendance officer really) onto the reports.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,968
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by tombry View Post
    one of the things I would love to see is to have some access to the pre-built lesson monitor reports to add in fields I'd like (or our attendance officer really) onto the reports.
    too right. if you compose the CR, i'll +2 it

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Lesson Monitor Percentage Attendance Report
    By saundersmatt in forum MIS Systems
    Replies: 3
    Last Post: 14th May 2012, 10:53 AM
  2. [SIMS] Sims Lesson / Attendance Report
    By IrritableTech in forum MIS Systems
    Replies: 10
    Last Post: 4th May 2012, 01:38 PM
  3. [SIMS] Late and Attendance Report
    By Tricky_Dicky in forum MIS Systems
    Replies: 0
    Last Post: 23rd April 2012, 12:36 PM
  4. [SIMS] Previous School Attendance Report
    By LosOjos in forum MIS Systems
    Replies: 2
    Last Post: 21st September 2010, 01:04 PM
  5. SIMS Attendence reporting
    By Stuart_C in forum MIS Systems
    Replies: 6
    Last Post: 3rd March 2009, 11:16 AM

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
  •