+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, CTF Attendance History - Reporting on . . in Technical; SO, the attendance from previous schools is brought into a pupil record, but we would like to be able to ...
  1. #1
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    128
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    13

    CTF Attendance History - Reporting on . .

    SO, the attendance from previous schools is brought into a pupil record, but we would like to be able to create a report for schools that will list the CTF attendance history of pupils. Can't find an entry in the reporting dictionary . . .

    Has anyone managed to do this?

    Thanks in advance.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    We don't store much previous data, so i can't check, but under the normal design reports screen. From a student focus - try going to History, which is about 8 from the bottom of the list, before you get all the sub-tables with blue icons. It may differ depending on your permission.
    Under that there is a table for previous schools, which i think should store the data you required, it even has it's own sub table which could get complex / cyclic.
    10-09-2011-12.16.59.jpg

  3. #3
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    128
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    13
    yup thanks vikpaw, found this area before but it lacks attendance totals for use in reporting. ITs is always frustrating when you can see the data in the system but cannot extract it (without directly querying the tables)

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Oops, sorry thought you meant you wanted a report for schools (in the db), not for schools you support. :s
    It is a pain not being able to extract all the data.
    You may have to look at extracting straight out of the CTF, or manipulating it and bringing it into an aspect. Not sure what a ctf looks like these days.

  5. Thanks to vikpaw from:

    SteveB (12th September 2011)

  6. #5
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    128
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    13
    Why didn't I think of that!! I've had my head buried in reports all morning designing and totally did not think about going back to the import. GJ

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    It's good to talk
    EduGeek: Let them do the thinking; so you don't have to.

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. Logging and reporting on pc idle time
    By danbuntu in forum Windows
    Replies: 0
    Last Post: 13th October 2010, 01:11 PM
  3. Sims.net - Reporting on Achievement and Behaviour
    By Iain.Faulkner in forum MIS Systems
    Replies: 22
    Last Post: 21st November 2009, 09:35 PM
  4. On-Line reporting requirements
    By witch in forum General Chat
    Replies: 5
    Last Post: 22nd May 2009, 01:21 PM
  5. [MS Office - 2003] Checking full revision history/summary on a document
    By Ben_Stanton in forum Office Software
    Replies: 2
    Last Post: 25th November 2008, 08:13 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
  •