Problem with Gantt Charts in v2011.1
Posted: Wed Jun 15, 2011 5:06 am
Hi, I hope someone can help me out here with creating Gantt chart in the latest release of Stimulsoft Reports.Net 2001.1.
I have created a simple SQL table with 3 columns for TaskName, StartDate, EndDate.
TaskName StartDate EndDate
Task 1 2011-02-01 00:00:00.000 2011-03-01 00:00:00.000
Task 1 2011-05-01 00:00:00.000 2011-08-01 00:00:00.000
Task 2 2011-04-01 00:00:00.000 2011-07-01 00:00:00.000
In my report I have done the following steps:
1. Create a new Connection/DataSource to my SQL Tasks table
1. Drag on a new chart from the toolbox
2. Double click on it and run the chart wizard
3. Select Gantt chart type
4. Default style 01
5. New Gantt series
6. Set Argument Data Column to Tasks.TaskName
7. set the Value Data Coulm to Tasks.StartDate
8. Select default None labels
9. Use default axis values
10. Finnish wizard
11. Double click on chart and set the ValueDataColumnEnd to Tasks.EndDate
When you preview the report I do not see what I would expect to see both tasks columns fill the width of the chart.
The XAxis labels starts from 30/12/1899 which is not very useful so I have set the Area > XAxis > Range > Auto to False, Maximum = 40908, Minimum = 40400
I got these values by getting the OLE application date value for 01/01/2011 - 31/12/2011 but I cant see any build in method of defining a Date Range using standard Date strings ?
Also there is a lack of Examples / Help / Videos on creating a Gantt chart ?
The Only way I can get the Gantt to display correctly is bu hard coding the the Series > ListOfValuesEnd property to 40603;40756;40725 whicha re the OLE Application date value for my End Dates but it should really be using the Series > ValueDataColumnEnd property ?
I have event tested against the the latest pre-release but that is completely broken in the build.
Any ideas of what I am doing wrong ?
Thanks,
Stewart
I have created a simple SQL table with 3 columns for TaskName, StartDate, EndDate.
TaskName StartDate EndDate
Task 1 2011-02-01 00:00:00.000 2011-03-01 00:00:00.000
Task 1 2011-05-01 00:00:00.000 2011-08-01 00:00:00.000
Task 2 2011-04-01 00:00:00.000 2011-07-01 00:00:00.000
In my report I have done the following steps:
1. Create a new Connection/DataSource to my SQL Tasks table
1. Drag on a new chart from the toolbox
2. Double click on it and run the chart wizard
3. Select Gantt chart type
4. Default style 01
5. New Gantt series
6. Set Argument Data Column to Tasks.TaskName
7. set the Value Data Coulm to Tasks.StartDate
8. Select default None labels
9. Use default axis values
10. Finnish wizard
11. Double click on chart and set the ValueDataColumnEnd to Tasks.EndDate
When you preview the report I do not see what I would expect to see both tasks columns fill the width of the chart.
The XAxis labels starts from 30/12/1899 which is not very useful so I have set the Area > XAxis > Range > Auto to False, Maximum = 40908, Minimum = 40400
I got these values by getting the OLE application date value for 01/01/2011 - 31/12/2011 but I cant see any build in method of defining a Date Range using standard Date strings ?
Also there is a lack of Examples / Help / Videos on creating a Gantt chart ?
The Only way I can get the Gantt to display correctly is bu hard coding the the Series > ListOfValuesEnd property to 40603;40756;40725 whicha re the OLE Application date value for my End Dates but it should really be using the Series > ValueDataColumnEnd property ?
I have event tested against the the latest pre-release but that is completely broken in the build.
Any ideas of what I am doing wrong ?
Thanks,
Stewart