RE: Attempting to setup DataType and DataStyle correctly

[Software FX]

Hello,

You should look into the crosstab provider that is currently out on beta.

http://support.softwarefx.com/beta

Justin Trask

Software FX

-----Original Message-----

From: Jonathon P. Gladieux [mailto:jpgladieux@qg.com]

Posted At: Monday, November 06, 2000 4:57 PM

Posted To: Server

Conversation: Attempting to setup DataType and DataStyle correctly 

Subject: Attempting to setup DataType and DataStyle correctly 

I have a sql statement that returns the following resultset

DateTime                                           Legend

Value

----------------------------------------------------------------------------

------------------------

Oct  1 2000  5:00AM                        MemPGFileUsage^^%

35.362959928720976

Oct  8 2000  5:00AM                        MemPGFileUsage^^%

37.303765531954511

Oct 15 2000  5:00AM                       MemPGFileUsage^^%

37.44519122320213

Oct 22 2000  5:00AM                       MemPGFileUsage^^%

37.246808014501248

Oct 29 2000  5:00AM                       MemPGFileUsage^^%

37.75940811167807

Oct  1 2000  5:00AM                        MemPhysUsage^^%

70.711202686131173

Oct  8 2000  5:00AM                        MemPhysUsage^^%

73.6383573868263

Oct 15 2000  5:00AM                       MemPhysUsage^^%

74.019691302705525

Oct 22 2000  5:00AM                       MemPhysUsage^^%

73.600927685435423

Oct 29 2000  5:00AM                       MemPhysUsage^^%

74.776226380684818

Oct  1 2000  5:00AM                        MemVirtualUsage^^%

9.5146011294756256

Oct  8 2000  5:00AM                        MemVirtualUsage^^%

9.4410242157835764

Oct 15 2000  5:00AM                       MemVirtualUsage^^%

9.6082678376442558

Oct 22 2000  5:00AM                       MemVirtualUsage^^%

9.6050705628849968

Oct 29 2000  5:00AM                       MemVirtualUsage^^%

9.6897064018917103

I have been trying to get the DataType and DataStyle properties to get what

I want before I give this resultset to AdoResultSet method.

However, I have had no success in getting a graph that is even close to what

I want.

Below are the configurations on what I am trying to do.  If anyone has any

ideas on how to do this with adoresultset let me know.

Configuration.

Construct n series based on Legend's distinct values.  In this case n would

be 3.

Construct m data points for each series based on the distinct values in

datetime for each series.  In this case m would be 5.

Populate data values with the values field.

Thanks.

Jonathon P. Gladieux