Gantt Chart

Gantt Chart

With this tutorial you will learn to create a Gantt chart from the structure of your table in the database to generate the chart itself. In this tutorial we will use a MYSQL database for table creation.


1. With the SQL command below will create the table and the fields used in the construction of the Gantt Chart. The script below is a table built from the SQL Builder option, which is found in the option (Database -> SQL Builder) in the top horizontal menu of ScriptCase.



 

2. To create a Gantt Chart is required consultation application (grid). Create an application grid and enable in Toolbar option and insert the Gantt.



3. Next, we must define the graph fields on Gantt settings.



4. We must associate the fields of the table with the graph, for the display correction of the information:


5. To display the chart, you should run the query application and click the chart button:


 

6.The graphic will be displayed in a new tab. This is an example of displaying using HTML 5.


    • Related Articles

    • New export formats in Chart applications

      With the new Scriptcase 9.1, new export formats were added to the Chart applications. Now it is possible to export to the formats PDF, WORD, XLS, XML, CSV, RTF, Image and Print. Check below the steps to enable the new export formats. In the Chart ...

    • Using tags in the Chart search

      When we are using the search in the Chart applications, we can enable the display of the tags for the searched values. This option can be adjusted in the Advanced Search settings. Enable the option Display tags. Next, run the application and access ...

    • Setting the Group by level in PDF exports of the Grid chart

      In the Grid applications, when the grid has more than one break level, it is possible to define what level of breakage the graph will be generated in the PDF export. To enable this option, go to the Export menu and enable the Level selection of the ...

    • Email Export in Charts

      In Chart applications you can configure the export by email feature. This feature is used to export the Charts and send the export directly by e-mail to the configured recipients. The e-mail export settings can be viewed in the Email Export menu. ...

    • Summary by Developers in Scriptcase

      In order to optimize project management, Scriptcase provides a summary report, where it is possible to view the production of each developer involved in the project we are accessing. 1. First, to have access to this report, we must access one of our ...