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.

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
Post a Comment