Tutorial: 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.