+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Clean Slate Report in Technical; Hi guys, I've been asked to write a 'clean Slate Report' for SIMS. Basically run a report to show which ...
  1. #1
    knightrider's Avatar
    Join Date
    Mar 2006
    Location
    Leeds
    Posts
    86
    Thank Post
    18
    Thanked 12 Times in 8 Posts
    Rep Power
    20

    Clean Slate Report

    Hi guys,

    I've been asked to write a 'clean Slate Report' for SIMS. Basically run a report to show which kids have got a present mark for every lesson and no behaviour points for a given week. I've been trying for a while but just cant seem to get it.

    Any help much apprecaited.

    Knightrider.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    771
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    I can give you my really bad way to do it.
    There's probably a more elegant solution, involving pivot tables or something.
    The report i've got, takes a long time to run, so it's worth doing it a year at a time, or maybe even smaller groups if you find it's still a chore.

    Basically, focus on students, on-roll.
    Add Name and Reg.

    Add Sub-Table for Behaviour (blue icons at bottom of fields list). It shows up as a count if you add no fields from the sub-table. Use the red icon on the right to show the sub-query table and put in a date between filter. Ignore the greyed out settings, it doesn't matter if it brings back all kids.

    Add Sub-Table for Lesson Marks. Again, don't pick any fields and it comes up as a count. Do a sub-query on date between AND mark type is one of '....' and choose all the absence codes, or the ones you want to penalise the kid for, including lates, if you want cleaner than clean.

    Both of these count columns will now have filtered next to them, but you can rename them at the top for disambiguity.
    Next page in wizard, if you add a filter of reg-group so it doesn't take half an hour to run, and send it to excel.

    You just need to sort by both count columns. Those with zero behaviour and zero absence marks are the ones you want.

    Not a great solution, i know, but it does the trick. You can probably get the result by focus on another area first, but i just do it this way.
    Apologies for the bare basic instructions, not sure if you're familiar with sub-queries, but it's useful for others anyway.

  3. Thanks to vikpaw from:

    knightrider (18th September 2012)

  4. #3
    knightrider's Avatar
    Join Date
    Mar 2006
    Location
    Leeds
    Posts
    86
    Thank Post
    18
    Thanked 12 Times in 8 Posts
    Rep Power
    20
    Thnaks Vik.

    Works a treat

    Knightrider



SHARE:
+ Post New Thread

Similar Threads

  1. What are your reporting methods?
    By indiegirl in forum How do you do....it?
    Replies: 21
    Last Post: 22nd June 2012, 10:58 AM
  2. Replies: 3
    Last Post: 10th March 2006, 02:54 PM
  3. Replies: 5
    Last Post: 5th March 2006, 02:22 PM
  4. Printing Access Reports... or not!
    By Frazer in forum Windows
    Replies: 0
    Last Post: 20th October 2005, 12:03 PM
  5. Getting your server to email you reports.
    By eejit in forum Windows
    Replies: 11
    Last Post: 23rd September 2005, 11:46 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
  •