August 9, 2010 at 2:49 am
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
August 9, 2010 at 3:27 pm
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]
August 9, 2010 at 6:26 pm
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?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply