Search found 177 matches

by robinwilson16
Tue Nov 08, 2016 11:43 pm
Forum: SSRS Reports
Topic: 3 Year Trend Withdrawals by Withdrawal Reason (ProAchieve)
Replies: 0
Views: 1417

3 Year Trend Withdrawals by Withdrawal Reason (ProAchieve)

Here is a report which uses ProAchieve data and looks at withdrawals by withdrawal reason over a 3 year period

Here is a preview and the RDL download is below:
Withdrawals by Withdrawal Reason.png
Withdrawals by Withdrawal Reason.png (54.83 KiB) Viewed 1417 times
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: 1280

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: 1313

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: 2539

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 2539 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: 1593

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: 1462

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: 1031

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: 752

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: 1516

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: 1315

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