On Scriptcase, it is possible to configure the Gant graphic exhibition option easily. Using a resource that is available on the application properties in consults, you can edit important configurations leaving your graphic much more customized.

To configure the Grant graphic properties is very simple. Open the properties of your consults type application and click on “Gant Graphic” on the left side menu.

Inside the screen that will open, you can edit the following items:

  • The output format is one of the HTML5 options;
  • The Label field;
  • Width and Height;
  • Quantity of months;
  • Initial and final graphic date;
  • The exhibition format;
  • Complete percentage of every activity;
  • Resource field exhibition on graphics;

The Gant graphic is utilized to help the project manager and we already talk about it in another opportunity here in our blog.

gant-graphic-chart

Tutorial in Scriptcase:

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.

Visit our blog and check out more articles like this one!

Learn all about Scriptcase.

By ,

November 27, 2013

a

You might also like…

9 Web Development and IT Trends for 2022

Check out in this article nine important web development and IT trends you should keep an eye on in...

October Newsletter

Follow the latest news for the month of October! Webinars, blog posts, videos, and more. WEB...

API: What is it? Which ones are available on Scriptcase?

Understand everything about what an API is, what they are for, and examples of APIs already integra...

You might also like…

Get new posts, resources, offers and more each week.

We will use the information you provide to update you about our Newsletter and Special Offers. You can unsubscribe any time you want by clinck in a link in the footer of any email you receive from us, or by contacting us at sales@scriptcase.net. Learn more about our Privacy Police.