reporting services - SSRS Timelime chart -


i'm trying create ssrs report graphically depicts time lime status true. have included simplified sample data in grid below. i'm looking create chart similar image below.

enter image description here

time                  status    person   2015-07-15 15:04:00        1         2015-07-15 15:05:00        0         2015-07-15 15:06:00        1         2015-07-15 15:07:00        1         2015-07-15 15:08:00        0         2015-07-15 15:09:00        0         2015-07-15 15:10:00        1         2015-07-15 15:04:00        1         b 2015-07-15 15:05:00        0         b 2015-07-15 15:06:00        0         b 2015-07-15 15:07:00        1         b 2015-07-15 15:08:00        1         b 2015-07-15 15:09:00        0         b 2015-07-15 15:10:00        0         b 

using same dataset provide in question maybe best approach this

moreover think easier if give try changing query getting duration of status event. way make range column chart , build chart want.

a custom property makes trick set drawsidebyside false.

check these examples:

http://blog.summitcloud.com/2009/11/ssrs-2008-gantt-charts/ http://pnarayanaswamy.blogspot.com/2010/09/range-bar-chart-gantt-chart-using-ssrs.html http://www.prasannaadavi.com/2012/05/creating-portfolio-timeline-using-ssrs.html


Comments