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] > On Apr 28, 9:08 pm, Paul Ritchie <REMOVEpritc...@xtraREMOVE.co.nz>
> wrote:
>
>> 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.
> 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 Consultan