This discussion is archived
4 Replies Latest reply: May 3, 2012 2:35 AM by 186943 RSS

Resource Gantt.

406120 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Markus,

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

    Sagar
  • 3. Re: Resource Gantt.
    904355 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points