Jump to content
Software FX Community

preSales Question


User (Legacy)

Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...