+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Serco Facility - is it possible to execute SQL in a report? in Technical; As per the title, i'm trying to find out if i can execute SQL queries from within a report - ...
  1. #1

    Join Date
    Mar 2008
    Location
    Norfolk
    Posts
    227
    Thank Post
    5
    Thanked 10 Times in 8 Posts
    Rep Power
    20

    Serco Facility - is it possible to execute SQL in a report?

    As per the title, i'm trying to find out if i can execute SQL queries from within a report - because of the curious way KS4 target data appears to be stored and accessed in Facility, this is the only method i can think might work to do what i want...

    Any ideas, if it is possible, how its done?

    Cheers...

  2. #2

    Join Date
    Mar 2008
    Location
    Derby
    Posts
    20
    Thank Post
    0
    Thanked 6 Times in 5 Posts
    Rep Power
    14
    Hello,

    What data are you trying to show the KS4 targets next to?

    Are the targets stored as assessment results?

    You should be able to bring them through your targets on to the report using the correct function/syntax.

    Regards,

    Nick

    Serco Learning Support

  3. #3

    Join Date
    Mar 2008
    Location
    Norfolk
    Posts
    227
    Thank Post
    5
    Thanked 10 Times in 8 Posts
    Rep Power
    20
    Thanks for your reply Nick; managed to get it sorted in the end by canabalising another Form report in the Serco Assessment folder and stealing its Embedded KS4 Target report. I was initially confusing myself by trying to copy the method used in a summary report which did odd things with default filters, etc - the SQL question was a result of trying to brainstorm a solution whilst sorting out a load of other issues. Never the best way to work!

    The end result is now a Form report that spits out three slips per A4 sheet that can be trimmed and laminated, that show pupil name, form group, photo, Fischer targets, KS4 targets and aspects of any vulnerable pupil status they may have, all against a coloured back drop where the colour is defined by gender and the vulnerable pupil status... Nothing too complicated, but it looks good and so i'm rather pleased with myself!

SHARE:
+ Post New Thread

Similar Threads

  1. serco facility
    By garrysaddington in forum MIS Systems
    Replies: 8
    Last Post: 8th June 2009, 10:22 AM
  2. Serco Facility Experiences!?
    By Nick_Young in forum MIS Systems
    Replies: 18
    Last Post: 6th March 2009, 03:10 PM
  3. Serco Facility and MS SQL server Express edition
    By cheredenine in forum MIS Systems
    Replies: 19
    Last Post: 19th December 2008, 06:42 PM
  4. Fronter and Serco Facility
    By cheredenine in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 10th November 2008, 08:24 AM
  5. Serco CMIS Facility
    By bursar in forum MIS Systems
    Replies: 11
    Last Post: 22nd May 2007, 04:36 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
  •