Search found 176 matches

by robinwilson16
Tue Nov 08, 2016 11:38 pm
Forum: SSRS Reports
Topic: 42 Day Check - To Check Learners Enrolled to Correct Level of Maths and English
Replies: 0
Views: 93

42 Day Check - To Check Learners Enrolled to Correct Level of Maths and English

This report lists each learners' enrolments with one per row and columns to indicate which QOE (Achievements on Entry) the learners achieved either elsewhere or here at Guildford College Group. I have build a custom QOE capture system here so the grades point to UNIT-e as well as my custom system so...
by robinwilson16
Tue Nov 08, 2016 11:28 pm
Forum: SSRS Reports
Topic: Enrolment Numbers by Programme
Replies: 0
Views: 96

Enrolment Numbers by Programme

Here is an enrolment numbers by programme report. As this report is designed to track numbers during main enrolment it uses the course funding model rather than the enrolment ILR funding model (25/35/99, etc). Here is a preview: Enrolment Numbers by Programme.png It does require a few tabled valued ...
by robinwilson16
Tue Nov 08, 2016 11:20 pm
Forum: SSRS Reports
Topic: Class List with Photos
Replies: 2
Views: 179

Class List with Photos

I have attached a class list with photos report which comes from UNIT-e.

Here is a preview:
Class List with Photos.png
Class List with Photos.png (132.08 KiB) Viewed 179 times
This does not require any functions and should work as is without any additional functions if you references are the same.

Hope it is useful :dance:
by robinwilson16
Tue Nov 08, 2016 8:46 pm
Forum: Bugs and Issues
Topic: Database Manager Users - Valid From and To Dates One Day Out
Replies: 2
Views: 113

Database Manager Users - Valid From and To Dates One Day Out

We have noticed that the logic for allowing people to log in is not quite right as when someone leaves the organisation, if we put the correct valid to date in then the system won't allow them to log in on their last day before they leave. If someone leaves on 08/11/2016 then the valid to date shoul...
by robinwilson16
Tue Nov 08, 2016 8:22 pm
Forum: Introductions
Topic: About Me John Ewens
Replies: 1
Views: 108

Re: About Me John Ewens

Hello John

Thanks for joining the forum.

Hopefully you will find it useful. 8-)

Feel free to ask on here if you have any SSRS questions.

Out of interest how do you currently make the reports available to staff?

Robin
by robinwilson16
Sat Nov 05, 2016 3:09 pm
Forum: SSRS/SQL Code Snippits
Topic: Identifying a student's "Main Aim"
Replies: 2
Views: 164

Re: Identifying a student's "Main Aim"

Hello John I have written a table valued function to do this which lists all a student's aims and then ordered them by various criteria taking the top one. This way it is guaranteed to return a value no matter the type of learner (EFA, SFA, Loans, HE, full cost, etc.) At Guildford College we have 4 ...
by robinwilson16
Tue Oct 25, 2016 10:53 am
Forum: SSRS/SQL Code Snippits
Topic: Calculating Distance Between Two Post Codes - As The Crow Flies
Replies: 0
Views: 150

Calculating Distance Between Two Post Codes - As The Crow Flies

I needed to work out how many miles away students are for support payments and thought I would share the code in case others find it useful. Please note that this is distance as the crow flies and not taking road layouts into account Step 1: Download Post Code Latitude and Longitude Source Data Down...
by robinwilson16
Wed Oct 19, 2016 6:03 pm
Forum: Bugs and Issues
Topic: System allows you to search without entering any search terms crashing the system
Replies: 2
Views: 107

System allows you to search without entering any search terms crashing the system

Screens in UNIT-e allow you to conduct a search when you have not entered any search terms. This is effect searches the entire system attempting to bring back all records. :think: The search button should not be live if no values have been entered or an error should be displayed telling you to first...
by robinwilson16
Wed Oct 19, 2016 10:06 am
Forum: Bugs and Issues
Topic: Booking Interviews
Replies: 0
Views: 91

Booking Interviews

Hello All It would appear that the interview booking process has changed at some point in a recent upgrade so now when pressing the activity button to record the date time of an interview this overly complex screen is displayed and the team are not sure what to put into the boxes and it doesn't seem...
by robinwilson16
Mon Oct 17, 2016 3:41 pm
Forum: Bugs and Issues
Topic: Block Mark Update
Replies: 2
Views: 136

Re: Block Mark Update

Hello

Thanks for posting this bug.
I have checked at Guildford College and we don't seem to have this issue here and do use this tool.
We have not yet upgraded to the 601 release and are still on 4.34.500.

Robin