error in aplying aggregate function when binding from datatable

[Kapil]

I am getting error while supplying aggregate function and then setting itemssource property of chart to datatable...

my code is like below..

   Dim sm As New SeriesMapping
        sm.SeriesDefinition = New LineSeriesDefinition
        sm.ItemMappings.Add(New ItemMapping("VDate", DataPointMember.XCategory))
        sm.ItemMappings.Add(New ItemMapping("Sales", DataPointMember.YValue, ChartAggregateFunction.Sum))
        rd.SeriesMappings.Add(sm)

rd.ItemsSource = DataSetMain.Tables(3)

Error i get...
"No generic method 'Sum' on type 'System.Linq.Enumerable' is compatible with the supplied type arguments and arguments. No type arguments should be provided if the method is non-generic."

Does that mean i cant use datatable which includes aggregate function or...if possible then then how?

[Ves]

Hello Kapil,

When databinding to DataTable you need to specify the field type explicitly:

ItemMapping mapping = new ItemMapping("Sales", DataPointMember.YValue, ChartAggregateFunction.Sum);
mapping.FieldType = typeof(double);

Sincerely ,
Ves
the Telerik team

[Kiran]

How do you do that in Javascript? 

[Martin Ivanov]

Hello Kiran,

This is the UI for WPF forum and it concerns the controls created for the WPF framework which doesn't use javascript. If you want to have a chart in HTML and use javascript you can see the Kendo UI chart component and post your question in the corresponding Kendo UI Forum.

Regards,
Martin
Telerik by Progress