SSRS gantt chartYou might be looking for SSRS Gantt Chart example well.... below is one of possible implementations. This gantt chart was created using tablix and bullet chart and below are elements we included: -- Gantt Chart Ranges: We have two ranges. The dark one is Start date to Target Date so target is when we would like to completed the milestone and it should give the time to react for worst case scenarios. The light range is Target to Deadline and if today's date is in this range it tells us that that there is a risk of missing the deadline. -- Gantt Chart Progress bar: This show percentage completed and it gives a very indications of where we are. If the end of the progress bar is after today's date then you are ahead of time but if it is before today's date then you might be behind your schedule which means that there is a potential risk of not delivering the milestone on time. This Gantt Chart shows start date, expected end date and dead line! Additionally the Gantt Chart show current progress as orange bar. If you noticed at the top of the Gantt Chart one of the dates has white background which is "today's date" and indicates where your progress bar (orange bar) should be. NOTE: This Gantt Chart is still in progress. 
Live SSRS Gantt Chart TestWould you like to see this report in action? Click the following link Milestone Scheduler Log In and type username: demo and password: demo you will be presented with dashboard and at the bottom you will get link to this report "detailed report".Related Internal Links: SSRS Gantt Chart - Heat Map Related External Links: SSRS Gantt Chart Take care Emil |
News & Updates: Follow @katieglowniaFollow @emilglownia
| You like it? Share it! |
Comments Add Comment
Name:
Michael Cruz
Comment: Are you able to walk through the steps to create the web page and supporting report files?
Date Posted: 09/08/2011 12:56:31 AM
Name: Emil
Comment: Hi The webpage is Visual Studio 2010 Web Page Template. A very good one I think. The report files are standard reports embeded into the page using report viewer. Let me know if you need more info on that.
Date Posted: 09/08/2011 5:54:13 AM
Name: Ravishankar
Comment: is it possible to share the steps as well the RDL file?
Date Posted: 06/09/2011 5:40:46 AM
Name: Emil
Comment: Hi I will not be able to share rdl file but I'm happyt to provide information how it was created. Those based in UK I invite you to SQL Bits 9 conference in Liverpool where I will discuss SSRS Gantt Charts (3 to be precise) Below is link http://sqlbits.com/Sessions/Event9/Advanced_SSRS_Find_out_what_you_have_been_missing This particular example uses only expressions to achieve the end result. However Bullet Chart that I used was quite problematic so I replaced it with subreport where I pass several parameters and then play with background colours using functions (SSRS Code) to make it appear as Gantt Chart. (I will post updated report soon)
Date Posted: 08/09/2011 3:24:45 PM
Comment: Are you able to walk through the steps to create the web page and supporting report files?
Date Posted: 09/08/2011 12:56:31 AM
Name: Emil
Comment: Hi The webpage is Visual Studio 2010 Web Page Template. A very good one I think. The report files are standard reports embeded into the page using report viewer. Let me know if you need more info on that.
Date Posted: 09/08/2011 5:54:13 AM
Name: Ravishankar
Comment: is it possible to share the steps as well the RDL file?
Date Posted: 06/09/2011 5:40:46 AM
Name: Emil
Comment: Hi I will not be able to share rdl file but I'm happyt to provide information how it was created. Those based in UK I invite you to SQL Bits 9 conference in Liverpool where I will discuss SSRS Gantt Charts (3 to be precise) Below is link http://sqlbits.com/Sessions/Event9/Advanced_SSRS_Find_out_what_you_have_been_missing This particular example uses only expressions to achieve the end result. However Bullet Chart that I used was quite problematic so I replaced it with subreport where I pass several parameters and then play with background colours using functions (SSRS Code) to make it appear as Gantt Chart. (I will post updated report soon)
Date Posted: 08/09/2011 3:24:45 PM
Add Comment