May 2, 2009 at 7:05 pm
Hi! I’m very new to SQL 2005 Sever. I’m wondering if there’s ways to write a query to display a graph showing times – like in Microsoft Outlook. I have data with rooms and in and out room times. I would like a graphic display showing when the rooms were & weren’t occupied. This graphic display would be weekdays, 6am thru to 8pm, on 3 rooms as day, for a month. Is this at all possible? I can query out the data points but I need help on how to get this displayed or even if this is possible. (3 rooms - a day - a colored bar showing when the room was occupied)
May 3, 2009 at 5:05 am
Hello,
One possibility might to be to create a Day as a Matrix. Each Room would be a Column and each Unit of Time would be a Row. In the underlying Dataset, return 1 if the Room is occupied during that Time and 0 if not. Then set the Background (and Foreground) Colour of the Cell to (as an example) Red if the value is 1 and White if it is 0.
Not a particularly elegant solution, but it’s the best I can think of at the moment. Hopefully somebody else will come up with a better idea.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
May 4, 2009 at 12:29 am
The functionality you describe can be found in SQL Reporting Services. Otherwise, you have to build your own front end display that interprets the data.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply