Search found 177 matches

by robinwilson16
Mon Oct 17, 2016 3:41 pm
Forum: Bugs and Issues
Topic: Block Mark Update
Replies: 2
Views: 1614

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
by robinwilson16
Mon Oct 17, 2016 9:31 am
Forum: SSRS Reports
Topic: Room Utilisation Report
Replies: 1
Views: 1542

Re: Room Utilisation Report

You will also need this table valued function that works out if a particular date is a teaching day or not: USE [GC] GO /****** Object: UserDefinedFunction [dbo].[College_Dates] Script Date: 17/10/2016 09:30:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[College_Da...
by robinwilson16
Mon Oct 17, 2016 9:30 am
Forum: SSRS Reports
Topic: Room Utilisation Report
Replies: 1
Views: 1542

Room Utilisation Report

Here is a copy of the room utilisation report we have developed in case it is helpful.
by robinwilson16
Mon Oct 17, 2016 9:27 am
Forum: SSRS Reports
Topic: Staff Utilisation Reports
Replies: 1
Views: 1397

Re: Staff Utilisation Reports

You will also need to add these table valued functions somewhere: USE [GC] GO /****** Object: UserDefinedFunction [dbo].[iFUN_ActivityStaffFaculties] Script Date: 17/10/2016 09:26:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[iFUN_ActivityStaffFaculties] ( @Sessio...
by robinwilson16
Mon Oct 17, 2016 9:23 am
Forum: SSRS Reports
Topic: Staff Utilisation Reports
Replies: 1
Views: 1397

Staff Utilisation Reports

I have attached Staff Utilisation Reports in case they are of use to other UNIT-e Colleges. They have been written directly in SQL and do not use RepGens. Here is a preview of what they look like when run: Summary: StaffUtilisation1.png By Faculty: StaffUtilisation2.png By Staff Member: StaffUtilisa...