Gantt

Dataset type available with bundle release 1.2.0 and onwards.

The Gantt dataset element has been developed as part of Reporter and is not part of the BFO used by NetSuite. This dataset allows you to present your data in a customizable Gantt chart within your PDF reports.

The dataset uses a single saved search to populate the Gantt and requires the below columns:

  • title

      • The name of the line, e.g. the name of the project task

      • string/text

  • startdate

      • The start date of the line

      • date

  • enddate

      • The end date of the line

      • date

The below columns are optional:

  • group (string/text)

      • The name of the parent or group, e.g. if the project tasks are grouped. Groups can be displayed together

  • percentcomplete

      • The status / job done in percentage for the individual task / line

      • Percentage

  • milestone

    • Milestones are highlighted in the gantt using a small flag icon.

    • Formula (text). Should return either 'T' or 'F'.

  • include

    • Should the line be printed in the gantt or not. Sometimes we might want to include lines or data in terms of sorting but not print everything.

    • Formula (text). Should return either 'T' or 'F'.

Make sure to read chapter Dataset Filtering on how to dynamically filter your search/data.

Formatting Gantt using CSS