all groups > sql server reporting services > april 2007 >
You're in the

sql server reporting services

group:

Gantt charts?


Gantt charts? Paul Ritchie
4/29/2007 2:08:10 AM
sql server reporting services:
I have a table with start and end dates for useage of an asset and would
like to generate a sort of gantt chart for a date range. ie a horizontal
bar graph like Microsoft Project with the assests down the left-hand-side
and dates along the top.

Is this possible with SSRS? I feel like I have read about RS features that
would assist with this but can not now find an example.

Any ideas would be much appreciated.

cheers,
Paul.

Re: Gantt charts? EMartinez
4/29/2007 10:29:56 AM
On Apr 28, 9:08 pm, Paul Ritchie <REMOVEpritc...@xtraREMOVE.co.nz>
[quoted text, click to view]


I myself haven't done Gantt charts via SSRS: it seems to be a rare
topic. This company seems to have experience in this area:
http://www.randsmanagement.com/
I would suggest using a stacked bar chart to accomplish this.

Regards,

Enrique Martinez
Sr. Software Consultant
Re: Gantt charts? Paul Ritchie
5/3/2007 4:03:08 AM
Thanks Enrique - your suggestion is much appreciated.

In the meantime I have returned a row for each day in the timeband by joining
to a table function that produces a row of each discrete date in the range.
I then created a matrix report for each cell and used colour coding to distinguish
from adjacent timebands and this will do for the moment.

I will definitely look at components such as this as soon as the client requests
an improvement on the above.

cheers,
Paul.


[quoted text, click to view]

AddThis Social Bookmark Button