User (Legacy) Posted October 4, 2005 Report Share Posted October 4, 2005 Hi, I am reviewing some different chart components in the market, and have a basic question on the chartfx for .net. I have a SQL result set that contains sales transaction data. One of the cols in the result set is the date of sale. The result set contains years of sales data, and I want to show the number of sales by month in a chart, so I can see which months where busy, and which months where not. Can the chart control itself do the grouping and totaling by months, or do I have to prepare the result set to contain this sort of data, rather than the raw data ? Hope that makes sense Thanks Link to comment Share on other sites More sharing options...
Software FX Posted October 6, 2005 Report Share Posted October 6, 2005 If you modify your SQL statement to returns the month in a column then you should be able to use our crosstab functionality to get the chart you want. -- JC Software FX Support "Aussie Rules" <someone@somewhere.com> wrote in message news:Wm8%230ZTyFHA.3776@webserver3.softwarefx.com... > Hi, > > I am reviewing some different chart components in the market, and have a > basic question on the chartfx for .net. > > I have a SQL result set that contains sales transaction data. One of the > cols in the result set is the date of sale. > > The result set contains years of sales data, and I want to show the number > of sales by month in a chart, so I can see which months where busy, and > which months where not. > > Can the chart control itself do the grouping and totaling by months, or do > I > have to prepare the result set to contain this sort of data, rather than > the > raw data ? > > Hope that makes sense > > Thanks > > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.