Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Visual Timeline of booked out equipment report Expand / Collapse
Author
Message
Posted Sunday, September 29, 2013 4:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, July 5, 2014 1:33 PM
Points: 33, Visits: 81
Hi,

I have a report request that is to show when equipment is in use and not. I want to try and display this in a visual way.

My idea (if possible) is to have

Equipment going down the page
Across the page show time slots starting at 9am and ending at 5pm. with 15 minute intervals. I always want to show all the times, even when the equipment is not in use. Then for each booked our range show which person has it.

I've googled around and looked at range charts and have a loose example of what I want to achieve

http://www.prasannaadavi.com/2012/05/creating-portfolio-timeline-using-ssrs.html

The issue with the above example is that it shows as a new line if you like the person who has the equipment. If possible I would like it on one line showing the gaps in the timeline where it is not in use as I think this will be much, much clearer.

Many thanks
Eliza



Post #1499745
Posted Tuesday, October 1, 2013 8:03 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:28 PM
Points: 64, Visits: 672
Have a look at this: http://www.sqlservercentral.com/articles/Job/101563/

Scroll halfway down the article too see the sample report
Post #1500434
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse