Time Series

[User (Legacy)]

Hi :

I would like to know how I can display a Time Series Data in Chart FX.  I

have the Data in a ADO Recordset  I bind it to the Chart with no problem but

I want to see the data the X axis been DateTime Field,Y Axis my values and

the PointID my Legend . The recordset is in the following and  format.

(First Field DateTime, second Field Point ID and Third Field Value)

DateTime1 DataPointName1 Value1

DateTime1 DataPointName2 Value2

DateTime1 DataPointName3 Value3

DateTime2 DataPointName1 Value1

DateTime2 DataPointName2 Value2

DateTime2 DataPointName3 Value3

DateTime3 DataPointName1 Value1

DateTime3 DataPointName2 Value2

DateTime3 DataPointName3 Value3

DateTime3 DataPointName2 Value2

I hope that I explain what I am trying to accomplish

Thanks

[User (Legacy)]

I found what was my problem.  I have to create a cross-tab query

thanks

"Julio Delgado" <jdelgado@jagautomation.com> wrote in message

news:xyYlpJxMBHA.2200@webserver1.softwarefx.com...

> Hi :

>

> I would like to know how I can display a Time Series Data in Chart FX.  I

> have the Data in a ADO Recordset  I bind it to the Chart with no problem

but

> I want to see the data the X axis been DateTime Field,Y Axis my values and

> the PointID my Legend . The recordset is in the following and  format.

> (First Field DateTime, second Field Point ID and Third Field Value)

>

> DateTime1 DataPointName1 Value1

> DateTime1 DataPointName2 Value2

> DateTime1 DataPointName3 Value3

> DateTime2 DataPointName1 Value1

> DateTime2 DataPointName2 Value2

> DateTime2 DataPointName3 Value3

> DateTime3 DataPointName1 Value1

> DateTime3 DataPointName2 Value2

> DateTime3 DataPointName3 Value3

> DateTime3 DataPointName2 Value2

>

>

> I hope that I explain what I am trying to accomplish

>

> Thanks

>

>