x

Gantt (Range) chart with multiple events per row

Hello,

I need to produce a Gantt chart in SSRS with multiple ranges per row. For example - Task 1 happens 3 time and Task 2 happens 4 times. But they must be on the same row - not succeeding rows.

As an example of what I mean here's a rough diagram.bad drawing of a gant chart

Finally: the data looks like this:

GantCheckID att1 startdatetime enddatetime

1 Data1 2012-10-31 09:14:18.650 2012-10-31 09:57:30.650

2 Data2 2012-10-31 07:33:30.650 2012-10-31 07:47:54.650

3 Data2 2012-10-31 09:14:29.650 2012-10-31 09:57:41.650

4 Data1 2012-10-31 07:33:41.650 2012-10-31 07:48:05.650

5 Data2 2012-10-31 16:57:02.210 2012-10-31 17:40:14.210

6 Data1 2012-10-31 08:04:14.210 2012-10-31 08:18:38.210

more ▼

asked Nov 16, 2012 at 02:08 PM in Default

avatar image

frambrose
30 1 1 2

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

It's not easy, but it is possible if you're willing to put the work in. Check out Narayana Swamy Palla's blog for one example, or David Leibowitz's blog for another. You might also want to check out this SQLBits presentation on advanced SSRS topics.

more ▼

answered Nov 16, 2012 at 02:34 PM

avatar image

Kevin Feasel
6.2k 4 8 15

(comments are locked)
10|1200 characters needed characters left

I think I'm going to be able to crack this now - thanks v much. The key to it- got from Narayana Swamy Palla's blog is: CustomAttributes: DrawSidebySide = False.

Then it's just a matter of fiddling around with what you call as series and what is a Category.

alt text

alt text

workings.png (34.4 kB)
display.png (31.7 kB)
more ▼

answered Nov 16, 2012 at 03:00 PM

avatar image

frambrose
30 1 1 2

Excellent. I'm glad that's working for you so far.

Nov 16, 2012 at 03:03 PM Kevin Feasel
(comments are locked)
10|1200 characters needed characters left

How can I achieve the same when dates are overlapping?,If the dates are overlapping, how can we achieve the same result by placing one legend in next row?

more ▼

answered Sep 01, 2014 at 12:19 PM

avatar image

su8resh4sql
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x713

asked: Nov 16, 2012 at 02:08 PM

Seen: 5365 times

Last Updated: Sep 01, 2014 at 12:19 PM

Copyright 2018 Redgate Software. Privacy Policy