Hi,
I'm looking at using the Chart Control for the first time and have a basic question before I begin. I have looked at the "Getting started" documentation and online videos but am a little unclear as to how to be the most efficient at getting some data into a chart.
My application already loads e.g. a main table at runtime with all "current clients". Each client is assigned to an employee and I'd like e.g. a pie chart to show the breakdown across employees: Employee A has 25 clients, Employee B has 36 clients etc etc.
My question is whether the Chart Control can look at this table and can summarise to get these totals within its built in functionality or do I have to provide a separate table with the summarised data directly from SQL Server. Or would you recommend I use a temporary table created at runtime? My dataset already has the appropriate relationships so I have functions like Row.GetTableBRows.Count at my disposal.
I have already looked through an online "How-to" but the example shows a product and the price straight from a table which isn't exactly the same format data as I have.
Many thanks.
Miles Young