Page 1 of 1

DB Chart TOrgSeries difficult to use

Posted: Thu Jan 31, 2008 8:59 am
by 10546183
I try to use TOrgSeries in a data aware chart

I thought that I could use X and Y values, but that doesn't work

It only uses Y values and the Y values must refer to the row number of the parent node (-1,0,1,2,1......) and not a database value.

This make it difficult to write a SQL (but not impossible) that gives the correct result set.

My suggestion is to use X and Y values as as Parent,Child fields.


I also have some more suggestions
1) add a collaps/expand buttons on the nodes
2)be able to configure the nodes with values from the dataset (color,shape....)

Jørgen

Posted: Thu Jan 31, 2008 10:52 am
by narcis
Hi Jørgen,
My suggestion is to use X and Y values as as Parent,Child fields.
Could you please describe in more detail how would you expect this to work exactly?

Thanks in advance.

Posted: Thu Jan 31, 2008 11:01 am
by 10546183
some thing like this
Name Id Parent

TopNode 12 null
ChildNode 14 12
ChildNode2 34 14
ChildNode3 13 34
ChildNode4 123 12
ChildNode5 2 123


It works if you have data like this:
TopNode -1
ChildNode 0
ChildNode2 1
ChildNode3 2
ChildNode4 0
ChildNode5 5
but this is hard to do because the value is the row number

Posted: Thu Jan 31, 2008 11:18 am
by narcis
Hi Jørgen,

Thanks for the information. I've added your requests to our wish-list to be considered for inclusion in future releases.

BTW: Current series' Add method returns an integer which is the point (or node in TOrgSeries) index in the series. Which, in the end, it is what you actually use.