... THEN t2.[Day]
ELSE NULL
END as 'Day',
CASE
WHEN t2.Day=t3.Day THEN t2.[Date]
ELSE NULL
END as 'Date',
CASE
WHEN t2.Day=t3.Day THEN t2.[Room]
ELSE NULL
END as 'Room',
CASE
WHEN ...
... , rb.[DateFinish]
, rb.[ContactUsername]
, rb.[ContactName]
, rb.[Room]
, rb.[BookingNotes]
FROM
roombookings rb
WHERE
rb.[GivenDate] BETWEEN @GivenDate AND @ToDate
AND
...
... expression as the one we use to get the equipment information:
SELECT
DISTINCT
re.[RoomId]
,re.[SiteId]
,re.[EquipId]
,eq.[Description]
FROM
[ROOMEQUIPMENT] re
INNER ...
... a new report:
We're going to run the wizard here but without it just add a matrix with [time] in the "column" and [room] in the "row" and [note/status] in the "data" cells.
2. Use the SQL ...
... dateadd(d, tt.[WeekDay] - 1, @baseDate)) AS 'Day',
tt.[SiteId] AS 'Site',
tt.[StartTime] AS 'Start',
tt.[FinishTime] AS 'Finish',
tt.[RoomId] AS 'Room',
sd.[Descrip] AS 'Event Type',
sd.[Notes] ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.