(UTC)
  The MindFusion Forums › Gauge and Chart Components › Windows Forms › How to group datatable?
(Moderator: Lyubo)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send TopicPrint
Normal Topic How to group datatable? (Read 4395 times)
peterherzig
YaBB Newbies
*
Offline


I love YaBB 1G - SP1!

Posts: 1
Joined: Aug 13th, 2008
How to group datatable?
Aug 13th, 2008 at 7:54pm
Print Post  
Suppose i have a table
year amount
2005   400
2008   100
2008   200

pieChartSmartView.DataSource = dt;
pieChartSmartView.DataField = "amount";
pieChartSmartView.OuterLabelsField = "year";

I want this to group on year and present the amount as a sum

Is this possible?
  
Back to top
 
IP Logged
 
Slavcho
God Member
*****
Offline


tech.support

Posts: 3152
Joined: Oct 19th, 2005
Re: How to group datatable?
Reply #1 - Aug 14th, 2008 at 11:10am
Print Post  
you should do that in the datasource' SELECT statement, for example

SELECT DISTINCTROW year, Sum(amount)
FROM table_name
GROUP BY year;
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send TopicPrint
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

The MindFusion Forums » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge