DB Chart TOrgSeries difficult to use

TeeChart VCL for Borland/CodeGear/Embarcadero RAD Studio, Delphi and C++ Builder.
Post Reply
jls
Newbie
Newbie
Posts: 30
Joined: Mon Jul 23, 2007 12:00 am

DB Chart TOrgSeries difficult to use

Post by jls » Thu Jan 31, 2008 8:59 am

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

Narcís
Site Admin
Site Admin
Posts: 14730
Joined: Mon Jun 09, 2003 4:00 am
Location: Banyoles, Catalonia
Contact:

Post by Narcís » Thu Jan 31, 2008 10:52 am

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.
Best Regards,
Narcís Calvet / Development & Support
Steema Software
Avinguda Montilivi 33, 17003 Girona, Catalonia
Tel: 34 972 218 797
http://www.steema.com
Image Image Image Image Image Image
Instructions - How to post in this forum

jls
Newbie
Newbie
Posts: 30
Joined: Mon Jul 23, 2007 12:00 am

Post by jls » Thu Jan 31, 2008 11:01 am

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

Narcís
Site Admin
Site Admin
Posts: 14730
Joined: Mon Jun 09, 2003 4:00 am
Location: Banyoles, Catalonia
Contact:

Post by Narcís » Thu Jan 31, 2008 11:18 am

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.
Best Regards,
Narcís Calvet / Development & Support
Steema Software
Avinguda Montilivi 33, 17003 Girona, Catalonia
Tel: 34 972 218 797
http://www.steema.com
Image Image Image Image Image Image
Instructions - How to post in this forum

Post Reply