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

Menu with Chart Applications

This example will use a menu treeview application to display the new charts generated by Scriptcase....

Using the Refined Filter

In this example we will develop a report using the refined filter option, which allows you to filter...

Percentage field

In this example we will see how to use the Percentage field available in the Grid. Configurin...

Comment this post