Timeline chart

• Jenny Richardson

  Ten Centuries

  Points: 1157

  More actions

  August 9, 2010 at 2:49 am

  #387526

  Hi all,

  I need to create a chart (in SSRS 2005) that shows the timeline for a piece of equipment over a period of time. Each row of data will have a start time, an end time and a category. E.g. here is some sample data:

  select '01/jan/2010 00:00' as starttime, '01/jan/2010 05:00' as endtime, 1 as category

  union

  select '01/jan/2010 05:00' as starttime, '01/jan/2010 05:30' as endtime, 2 as category

  union

  select '01/jan/2010 05:30' as starttime, '01/jan/2010 06:00' as endtime, 3 as category

  union

  select '01/jan/2010 06:00' as starttime, '01/jan/2010 09:00' as endtime, 1 as category

  I have tried a stacked bar chart in SSRS, and can almost get what I need, although the axis cannot be labelled with times, only with duration. I have also tried using the Dundas Gantt chart (see attached) and this lets me use times for the axis.

  However - the problem is that we need to be able to see the start/end times on the chart itself. If I use labels these can quickly become difficult to read, as I can't seem to display them above/below the bar, only overlay them on the bar itself. An alternative might be a tooltip, where you hover over the particular part of the bar and see the start/end times, but it seems I need SSRS 2008 for that.

  Has anyone done anything like this before?

  Thanks

  Jenny

• Baskar B.V

  SSCrazy

  Points: 2823

  More actions

  August 9, 2010 at 3:27 pm

  #1204431

  I have tried a stacked bar chart in SSRS, and can almost get what I need, although the axis cannot be labelled with times, only with duration. I have also tried using the Dundas Gantt chart (see attached) and this lets me use times for the axis.

  However - the problem is that we need to be able to see the start/end times on the chart itself. If I use labels these can quickly become difficult to read, as I can't seem to display them above/below the bar, only overlay them on the bar itself. An alternative might be a tooltip, where you hover over the particular part of the bar and see the start/end times, but it seems I need SSRS 2008 for that.

  Have you tried the "chart" control in the toolbox set?

  [font="Arial"]BASKAR BV
  http://geekswithblogs.net/baskibv/Default.aspx
  In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

• Jenny Richardson

  Ten Centuries

  Points: 1157

  More actions

  August 9, 2010 at 6:26 pm

  #1204463

  Yes - a stacked bar chart is a type of chart, created using the chart control.

  Is there another type of chart I can use for this purpose?