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

[cheredenine]

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...

[NickBuckel]

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

[cheredenine]

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!