4 Replies Latest reply on May 3, 2012 9:35 AM by 186943

    Resource Gantt.

    Sagar Doriwala
      HI,

      Need help on Resource Gantt.
      Click on below link to see what type of view I am trying to achieve

      http://anychart.com/products/anygantt/online-demos/resource-chart-editor/index.html


      Here is my table script

      CREATE TABLE TB_EMPALLOC
      (     EMPNO NUMBER,
           EMPNAME VARCHAR2(100),
           PROJECTNAME VARCHAR2(100),
           PROGRAMNAME VARCHAR2(100),
           STARTDATE TIMESTAMP (6),
           ENDDATE TIMESTAMP (6),
           ALLOCATION NUMBER,
           PROJECTID NUMBER,
           MGR_NAME VARCHAR2(100)
      )
      /
      Chart Series: Query
      SELECT NULL LINK, EMPNO RESOURCE_ID, ENMPNAME RESOURCE_NAME, NULL PARENT_ID, STARTDATE ACTUAL_START, ENDDATE ACTUAL_END
      FROM TB_EMPALLOC

      Error I get
      Category: XML errorError
      Code: 11001
      Message: No project data was found

      Here is my app
      http://apex.oracle.com/pls/apex/f?p=49598:8