+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, SIMS Report in Technical; ...
  1. #1
    knightrider's Avatar
    Join Date
    Mar 2006
    Location
    Leeds
    Posts
    85
    Thank Post
    18
    Thanked 10 Times in 7 Posts
    Rep Power
    19

    SIMS Report

    Afternoon,

    I've been asked to write a 'clean slate' report i.e a report which shows which pupils have got:

    100% Am & PM Attendance for the last week
    0% late’s for the last week
    0 behaviour points for the last week


    Now I thought I'd cracked it but I've been given some names of pupils that should be on this but I can't for the life of me work out why they don't. I think the part I'm struggling with is getting this data for the previous week and not the entire year.

    Hope that all makes sense.

    Any help much appreciated

    Knightrider

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Can you share the report so we can see it?
    The attendance part should be straight forward, and you can put date ranges in.
    Ditto for behaviour i think, but it's a bit more complex. However combining the two is the bit i'm not sure about, it should work okay.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I just tried one based on student focus, with two sub queries. One counts students with marks between fixed dates, that are not of an absence type, and the other which counts behaviour between fixed dates with points greater than 0. It means you'd have to filter the results to find those with a 10 for the number of marks which you could see by sorting the report so the only manual bit would need to check for those with no behaviour incidents with points, so just cherry pick zeroes in that section of the list. not ideal, but could work. there are probably better ways on a different focus.

  4. #4
    tmcd0035's Avatar
    Join Date
    Feb 2012
    Location
    Norwich
    Posts
    17
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Honestly not looked at the problem per se, just thought I'd suggest a different approach that I've used when I can't get SIMS to spit out the dataset I require.

    How about exporting two reports that each give half the answer into Excel and then using Excel to compare the two giving the final dataset?

  5. #5
    MikeW's Avatar
    Join Date
    Nov 2005
    Location
    Marple, Cheshire
    Posts
    14
    Thank Post
    39
    Thanked 1 Time in 1 Post
    Rep Power
    18
    Struggling with a similar issue - trying to create a report showing all students in specific reg groups with 100% attendance over the previous 4 weeks and then schedule it for individual form tutors. Can't see a method of exporting the 'inbuilt' Percentage Attendance report to enable me to edit it, reimport and then use with the SIMS scheduler.

  6. #6
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Answered on SupportNet!

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Reporting on Email Address contents
    By pete in forum MIS Systems
    Replies: 8
    Last Post: 15th July 2011, 12:10 PM
  2. [SIMS] Parameters in SIMS reports
    By iceman in forum MIS Systems
    Replies: 2
    Last Post: 22nd April 2011, 12:04 PM
  3. [SIMS] SIMS Report Writing
    By Progeniga in forum MIS Systems
    Replies: 4
    Last Post: 11th February 2011, 04:02 PM
  4. [SIMS] SIMS report to output students who have a birthday today
    By cjohnsonuk in forum MIS Systems
    Replies: 9
    Last Post: 6th January 2011, 01:37 AM
  5. [SIMS] Sims report ignoring my filters? [SOLVED]
    By localzuk in forum MIS Systems
    Replies: 4
    Last Post: 15th November 2010, 01:00 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
  •