Search found 176 matches

by robinwilson16
Mon Oct 17, 2016 9:31 am
Forum: SSRS Reports
Topic: Room Utilisation Report
Replies: 1
Views: 132

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

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

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

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...
by robinwilson16
Mon Oct 17, 2016 9:11 am
Forum: Useful Links
Topic: The HUB
Replies: 0
Views: 74

The HUB