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 - ...
8th October 2009, 10:55 AM #1
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?
9th October 2009, 08:50 AM #2
- Rep Power
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.
Serco Learning Support
9th October 2009, 10:35 AM #3
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!
By garrysaddington in forum MIS Systems
Last Post: 8th June 2009, 10:22 AM
By Nick_Young in forum MIS Systems
Last Post: 6th March 2009, 03:10 PM
By cheredenine in forum MIS Systems
Last Post: 19th December 2008, 06:42 PM
By cheredenine in forum Virtual Learning Platforms
Last Post: 10th November 2008, 08:24 AM
By bursar in forum MIS Systems
Last Post: 22nd May 2007, 04:36 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)