Gantt Chart
Hi, It would be great if I can get a Gannt Chart (.RDL file) from the below data. I already tried with the link http://jetlounge.net/blogs/teched/archive/2007/12/21/gantt-charting-with-reporting-services.aspx but I can`t get it work. The main thing need to be focussed here is with the Start and End Dates as I have TIME in my dates and the time need to be shown on the Gantt Chart along with the tasks. Please, I need .rdl file so that I can understand and work quickly. I need the Gantt Chart which looks same like in the link http://jetlounge.net/blogs/teched/archive/2007/12/21/gantt-charting-with-reporting-services.aspx CREATE TABLE [dbo].[GCTable]( [Project] [nvarchar](50) NOT NULL, [Task] [nvarchar](50) NULL, [StartDate] [smalldatetime] NULL, [EndDate] [smalldatetime] NULL ) ON[PRIMARY] GO INSERT INTO GCTable VALUES('Gantt Chart 2011', 'A','2011-02-17 18:30:00.000','2011-02-17 20:30:00.000') GO INSERT INTO GCTable VALUES('Gantt Chart 2011', 'B','2011-03-23 17:30:00.000','2011-03-23 22:00:00.000') GO INSERT INTO GCTable VALUES('Gantt Chart 2011', 'C','2011-03-24 18:00:00.000','2011-03-24 19:00:00.000') GO INSERT INTO GCTable VALUES('Gantt Chart 2011', 'D','2011-03-24 18:00:00.000','2011-03-24 18:30:00.000') GO INSERT INTO GCTable VALUES('Gantt Chart 2011', 'E','2011-03-24 19:00:00.000','2011-03-24 20:30:00.000') GO SELECT Project, Task, StartDate, EndDate FROM GCTable
March 29th, 2011 1:19am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics