Gantt Chart

This example shows how to create a report showing the Gantt chart.

Creating a new Grid

1. Create a new grid application based on the following SQL.

SELECT
project.projectname,
tasks.taskid,
tasks.projectid,
tasks.taskname,
tasks.milestone,
tasks.startdate,
tasks.finishdate,
tasks.percentcomplete,
tasks.actualfinishdate,
tasks.daysoverdue,
tasks.taskpredecessor,
tasks.taskstatus 
FROM
project, tasks 
WHERE 
project.projectid = tasks.projectid
ORDER BY 
project.projectname,
tasks.startdate

2. Access the item “Fields Positioning”.

3. Select to display the following fields:

Configuring the Filter

4. Return to the item “Modules Grid” and check the “Search” as the initial module.

5. In the Search tab to access the “Advanced filters >> Select fields”.

6. Select the field tasks.projectid.

7. Still in the Search tab, visit the edition of tasks.projectid field.

8. Change the field type to “Select” and use the following code in SQL Lookup.

select projectid, projectname 
from project 
order by projectname

Configuring the Gantt chart

9. Visit the option “Gantt” in the application menu.

10. Set the properties according to the image below.

11. Access the settings of the “Toolbar”.

12. Select to display the Gantt chart button.

10. Click the Run button on the toolbar.

Tutorials in the same category

Analyical Chart

In this example we will see how to create an analytic chart using the Grid application. Creating a...

Analytical Radar Chart

In this example we will see how to create an analytic Radar chart using the Grid application. Crea...

Chart with link to another chart

In this example we will see how to create and use a link between Charts, allowing the end user to na...

Chart with Link

In this example we will see how to create and use a link between the Chart and the Grid, allowing th...

Comment this post