Gantt Chart

This example shows how to create a report that shows 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
ORDERBY
project.projectname,
tasks.startdate 

2. Access the item “Field positioning”.

3. Select to display the following fields:

Configuring the filter

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

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

6. Select the tasks.projectid field.

7. Still on the Search tab, visit the task editing field.

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

select projectid, projectname 
from project 
order by projectname

Configuring the Gantt chart

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

10. Set the properties according to the image below.

11. Access the “Toolbar” settings.

12. Select to display the Gantt chart button.

13. Click on the Run button on the toolbar.

Tutorials in the same category

Chart / Trend Zone

To place a trend line within our charts, the following steps must be performed: 1 - Create a...

Toolbar for Charts

In this tutorial we will be looking at how to create a Chart with toolbar options. Creating ...

Chart Multiple Series

In this example we will see how to create a chart of Multiple series. 1- Create a new applic...

Chart Stacked – Column

In this tutorial we will be looking at how to create a Chart of Stacked Columns. 1- Create a...

Comment this post