RadChart control Gantt charts

[Rajesh]

Hi,

I'm trying to build a grantt chart with the data shown below using data bind control but when I click on the data tab of the wizard the propert screen just closes.

ProjectName	Project Start Date	Project End Date
CISF	10/12/2008	11/1/2008
Dashboard	10/10/2008	11/1/2008

Can someone help me create a grantt chart with the above data.

This happens when the chart type is set to Grantt but the rest of the chart types work perfectly

[Ves]

Hello Rajesh,

The reason for this is that RadChart does not support DateTime values out of the box. However, you can use their ToOADate equivalents. You can find an example here. In order to use this with SqlDataSource you will need to create your query so, that it returns the OleAutomation equivalents of the date values -- this is done like this:
SELECT CAST(MyDate as FLOAT) + 2 as MyFloatDate.....

Please, find attached a sample page, showing a gantt chart databound to a SqlDataSource control. I have chosen the date columns in the Employees table in Northwind. Hope this helps.

Regards,
Ves
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Abhishek]

Hi,
   I am trying to develop gantt chart by using radchart control. up to this moment what i have done is here ,i have two drop down list first one is project name and second one is milestone name after clicking both drop down one grid will be displayed in which all task name and its start and end dates will be display related to that project and milestone. and i have shown that task name and its start date and its end date in the gantt chart on the yaxis2
 I have displayed dates with short date() but now i want to display  that whole dates into different format like i want to break down that dates into four layers first layer is year second layer is month third layer is week and then days

so please suggest me or help me to display data into this format which properties i have to set or helpful for me
and if you provide source code regarding that then it is helpful for me.

for your more information here i attach one screen shot if my work

[Danail Vasilev]

Hi Abhishek,

What I can suggest is that you set the following properties for both YAxes:

• ValueFormat - to ChartValueFormat.ShortDate or ChartValueFormat.LongDate
• CustomFormat - to the desired custom format string (i.e. "yyyy", "MM", etc.).

Please find a runnable example in the attached archive that illustrates the above.

Note also that currently a pure Gantt chart is not available in the ASP.NET AJAX suite. Such a feature request, however, has already been logged here, so that you can monitor, comment or raise its priority by voting on it. I can also suggest that you examine the RadGanttView for Silverlight demo to see if it fits your needs.

Regards,
Danail Vasilev
Telerik

[Pavan]

Hi Abhishek,
Your example looks nice. Can you share your code with us if possible. or how can we display the tasks on left side instead inside the chart, and display the dates on top? Thanks in advance.

[Danail Vasilev]

Hello Pavan,

In order to display dates on the top you can change the series orientation to horizontal and use the second y-axis for the series. For example:

RadChart1.Series[0].YAxisType = ChartYAxisType.Secondary;
RadChart1.SeriesOrientation = ChartSeriesOrientation.Horizontal;

Regarding the displaying of the series items' labels outside of the plot area, I am sorry to say that this is no achievable with the current implementation of the control.

You can find the full runnable VS example in the attached archive.

Regards,
Danail Vasilev
Telerik