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

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

Chart of Combination

In this tutorial we will be looking at how to create a chart of the type Combination. Creati...

Comment this post