sorting summary series by group value

[jls]

I try to sort a summary series by the group value.

This work if the group values are text, but if the group value is numeric or dates it is wrong.

In this cases the labels are sorted by the numeric text/ date as text not the value.

eg numeric is sorted like this:
0.1.11.2.2222,9
should be
0,1,2,9,11,2222

How can I solve this?

Jørgen

[Pep]

Hi Jørgen,

changing the axis label style to talValue should solve it :
Chart1.Axes.Left.LabelsStyle := talValue;

[jls]

This doesn't work for datetime values.
The are displayed as 0,1,2,3,4....



Jørgen

[Pep]

Hi Jørgen,

have you set the values to datetime ?
TChart1.Series(0).YValues.DateTime = True

[jls]

I tried to set .DateTime = True
but this doesn't help



The problem is with grouped DBCharts

The values are grouped by a datetime field.


I have now changed my code to sort the dataset. This works, but it should have worked with teechart sorting to.,

Is it possible to sort a grouped chart where the grouped value is DateTime/ numbers ?


Jørgen

[Pep]

Hi J

it should work just using :

Code: Select all

  dbchart1.Axes.Bottom.LabelStyle := talValue;
  series1.xvalues.DateTime := true;
  Series1.XValues.Order:= loAscending;

  ComboBox1.ItemIndex:=2;
  ComboBox2.ItemIndex:=0;

I've tried it here with the demo "dbChart_Summary.pas" included into the TeeNew8 demo project, just adding the above lines into the formShow and openning the table it sorts the datapoints by date.