Topic: Advance gantt chart like attached picture

is there any way to draw chart like in the picture.
my goal is to modify the example gantt chart posted on the forum to display two rows for a single task. one is for expected date of start & end & other is Actual date of start & end. any suggestion is highly appreciated.

Post's attachments

Attachment icon New Bitmap Image.bmp 569.06 kb, 173 downloads since 2019-04-03 

Re: Advance gantt chart like attached picture

I can do it using current project without modification, example:

Post's attachments

Attachment icon Gantt TreeView_actual_projected.zip 14.08 kb, 75 downloads since 2019-04-05 

Dmitry.

3 (edited by nrmuduli 2019-04-06 03:59:36)

Re: Advance gantt chart like attached picture

thanks for the reply.
let me elaborate more. first i have 5 nos of running projects, each project having number of tasks & each task having actual & projected time lines.
in this situation i can not think of how to take up the job.

thanks....

Post's attachments

Attachment icon New Bitmap Image.bmp 530.72 kb, 94 downloads since 2019-04-06 

Re: Advance gantt chart like attached picture

nrmuduli wrote:

thanks for the reply.
let me elaborate more. first i have 5 nos of running projects, each project having number of tasks & each task having actual & projected time lines.
in this situation i can not think of how to take up the job.

thanks....

I made an example for you

Post's attachments

Attachment icon Gantt TreeView_actual_projected.zip 16.15 kb, 99 downloads since 2019-04-09 

Dmitry.

Re: Advance gantt chart like attached picture

THANKS Dimitry.....

6 (edited by nrmuduli 2019-05-17 09:35:17)

Re: Advance gantt chart like attached picture

HELP, It is not working in mysql connection.
completed my project in sqlite which is running & results are correct.
mysql server version: 5.7.20
mvd: 5.4 trail

further error shows during syntax check
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLQuery('SELECT id, id_Project  , Start, End, StartActual, EndActual,Comment FR' at line 1

Re: Advance gantt chart like attached picture

Try to get all fields in backticks

`id`, `id_Project`, `Start`, `End`, `StartActual`, `EndActual`, `Comment FR`
Dmitry.

Re: Advance gantt chart like attached picture

STILL NOT WORKING

Re: Advance gantt chart like attached picture

nrmuduli wrote:

STILL NOT WORKING

Fixed.

Post's attachments

Attachment icon Gantt TreeView_actual_projected_MySQL.zip 14.81 kb, 60 downloads since 2019-05-23 

Dmitry.

Re: Advance gantt chart like attached picture

thanks....
now its working..... smile

Re: Advance gantt chart like attached picture

Hii,

1. is there any way to filter only projects that are running in current  month or the selected time period.
2. and second is, if i want to show only one project in tree view can it be possible.