I've got an article over at SQL Server Central that describes how to get Gantt charts in SSRS using native controls, not third party. And it has a holiday spin.
This is the abstact:
Gantt charts in SSRS aren’t included in the 2005 release. You can purchase a third-party add-on, or, if you can wait, these powerful project tools might make it in the 2008 release. Or Alternatively, you can do this now with the native RS Chart control by using the methods David Leibowitz provides with the native RS Chart control.
This is the URL: http://www.sqlservercentral.com/articles/Reporting+Services/Santa+gets+an+RDL+present/61782/
The RDL example file is found in the Attachment link below.
Hye David.
I had to work on a similare chart. And when came the hard stuf I began browsing around and found your Gantt Chart Exemple. Not far from what I achieved my self but mine isn't working as well. My problem: The durations of the "tasks" on my project is Seconds and not days.
If my firt value for the bar is a number of second from the begining of the day , I get the picture I want exept the Y axis can't show me time stamp since I daediff(ss is integers...)
But If I put my first value as a datetime I can get the Y axis to show me the time line, but its look like my other values coming from datediff(ss,....) are adding days and not second...
I tried rewriting my statement to provide only delta in datetime format but that doesn't do it...
I'm a bit stuck How can I tell SSRS that the data for the next bars are seconds so they can add to one another keeping in range of theY-axis... ?
You're welwcome if You have any idea.
juste in case you would like to answer You'll probalby find it convinent to get my E-mail... donoyer(at)gmail.com
Thanks for your concern
Yes Chris Donoyer Again. Thanks to the inspiration...
The solution to my issue was quiet simple in fact.
I finnaly use a simple substract between my two date and ceonverted the result to float.
Then doing the same way you did, first field is date time and other fields adds float numbers.
It's sound so simple at the end...
Thanks again for the inspiration, Finding my RDL wasn't too far from your tuto gave me confidence I was on the right way... So many thanks.
Refer to the recent post I have made in the discussion forum linked as it describes the missing details within it to help anyone struggling with this situation:
www.sqlservercentral.com/.../Topic435491-1162-2.aspx