User (Legacy) Posted May 1, 2002 Report Share Posted May 1, 2002 Has anyone been able to get more than one series using a DataSet Object. I am trying to chart the data the below listed sample. I would like to have two series one for Division 1 and one for Division 2. Is this possible with ChartFX.Lite.Net? I have the following table (DIVISION_SALES): WEEK_NUM fiscal week number DIVISION Company Division SALES Amount of sales for this division Sample Data: ROW WEEK_NUM DIVISION SALES 1 1 1 10 1 1 1 10 1 1 1 10 1 1 1 10 1 1 1 10 1 1 1 10 1 1 2 20 1 1 2 20 1 1 2 20 1 1 2 20 1 1 2 20 1 1 2 20 Link to comment Share on other sites More sharing options...
User (Legacy) Posted May 1, 2002 Author Report Share Posted May 1, 2002 Has anyone been able to get more than one series using a DataSet Object. I am trying to chart the data the below listed sample. I would like to have two series one for Division 1 and one for Division 2. Is this possible with ChartFX.Lite.Net? I have the following table (DIVISION_SALES): WEEK_NUM fiscal week number DIVISION Company Division SALES Amount of sales for this division Sample Data: ROW WEEK_NUM DIVISION SALES 1 1 1 10 1 1 1 10 1 1 1 10 1 1 1 10 1 1 1 10 1 1 1 10 1 1 2 20 1 1 2 20 1 1 2 20 1 1 2 20 1 1 2 20 1 1 2 20 Link to comment Share on other sites More sharing options...
Software FX Posted May 3, 2002 Report Share Posted May 3, 2002 Our default behavior is to use multiple numeric columns in your SQL statement as different columns, what you are trying to accomplish is typically called Crosstabs. Our .NET charts (lite or full) do not support this at the moment but we will support it in the near future for the full version. I am afraid you will have to manually loop through your recordset and pass the data depending on your "pivot" fields. Note that Access supports crosstabs natively but AFAIK SQLServer and Oracle do not. -- Regards JC Software FX Support "Jay W. Smith" <jay.w.smith@tyson.com> wrote in message news:StD9IyU8BHA.1268@webserver1.softwarefx.com... > Has anyone been able to get more than one series using a DataSet Object. > > I am trying to chart the data the below listed sample. I would like to have > two series one for Division 1 and one for Division 2. Is this possible with > ChartFX.Lite.Net? > > I have the following table (DIVISION_SALES): > > WEEK_NUM fiscal week number > DIVISION Company Division > SALES Amount of sales for this division > > Sample Data: > ROW WEEK_NUM DIVISION SALES > 1 1 1 > 10 > 1 1 1 > 10 > 1 1 1 > 10 > 1 1 1 > 10 > 1 1 1 > 10 > 1 1 1 > 10 > 1 1 2 > 20 > 1 1 2 > 20 > 1 1 2 > 20 > 1 1 2 > 20 > 1 1 2 > 20 > 1 1 2 > 20 > > Link to comment Share on other sites More sharing options...
Software FX Posted May 3, 2002 Report Share Posted May 3, 2002 Our default behavior is to use multiple numeric columns in your SQL statement as different columns, what you are trying to accomplish is typically called Crosstabs. Our .NET charts (lite or full) do not support this at the moment but we will support it in the near future for the full version. I am afraid you will have to manually loop through your recordset and pass the data depending on your "pivot" fields. Note that Access supports crosstabs natively but AFAIK SQLServer and Oracle do not. -- Regards JC Software FX Support "Jay W. Smith" <jay.w.smith@tyson.com> wrote in message news:StD9IyU8BHA.1268@webserver1.softwarefx.com... > Has anyone been able to get more than one series using a DataSet Object. > > I am trying to chart the data the below listed sample. I would like to have > two series one for Division 1 and one for Division 2. Is this possible with > ChartFX.Lite.Net? > > I have the following table (DIVISION_SALES): > > WEEK_NUM fiscal week number > DIVISION Company Division > SALES Amount of sales for this division > > Sample Data: > ROW WEEK_NUM DIVISION SALES > 1 1 1 > 10 > 1 1 1 > 10 > 1 1 1 > 10 > 1 1 1 > 10 > 1 1 1 > 10 > 1 1 1 > 10 > 1 1 2 > 20 > 1 1 2 > 20 > 1 1 2 > 20 > 1 1 2 > 20 > 1 1 2 > 20 > 1 1 2 > 20 > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.