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

    Resource Gantt.

    406120
      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
        • 1. Re: Resource Gantt.
          fiedlerm
          Hi Sagar,

          there are lot examples in this forum.

          Maby this helps:

          http://apex.oracle.com/pls/apex/f?p=36648:60

          Markus
          • 2. Re: Resource Gantt.
            406120
            Markus,

            I started building chart series only after looking this example. still doesn't owrk.

            Sagar
            • 3. Re: Resource Gantt.
              904355
              Hi Sagar,

              I do not think that this template of chart is available for us. I think this is a later version of AnyChart that Oracle does not have yet.

              I looked at your demo and it seems it does what it should do. By the way, did you find a way to include the task name somewhere in the tooltip/hint or even in the columns?

              If you have any idea, I would be grateful if you can share this with us.

              Thanks,
              Mohamed
              • 4. Re: Resource Gantt.
                186943
                Hi,
                I had exactly the same error. By default the maximum rows attribute within the query series is set to 15. If your query returns more than 15 rows, you will get this error. Set the maximum rows value to something greater than the number of rows rewturned by your query.


                Mike