I've enabled SummarRowSettings on my grid, but do not see the "Sum" checkbox, I do see the Count, Min and Max checboxes....
I've explicitly set the column datatype as double, using the code below..
xamGrid1.ColumnTypeMappings[columnIndex].DataType = typeof(double);
Pls. assist why I'm not able to see the "sum" checkbox at the top and also the sorting of the column seems to be string based (instead of double)...
Thanks
no the column's data type is fixed.
You could try using an unbound column and using a value converter to switch your value. you could create custom summaries to handle a string to double conversion, a custom sort comparer to do the comparision for you in double rather then string.
If you have control of the Data object you could make a property off the data object that does the conversion for you and represent your data in a different form.
You cannot change the data type of a column, it's going to take the the datatype of the underlying data.
So from what you posted, your data is probably a string, and not a double, and "sum" is only valid for numeric types.
ColumnTypeMappings
http://help.infragistics.com/NetAdvantage/Silverlight/2010.3/CLR4.0/?page=SL_xamGrid_Change_Column_Type_Mapping.html
This collection is used to map what type of data to map to a column type, not to change the data type.
So this collection would say, if you see a string based column use a text column, if you see a datetime property use a DateColumn. What you are doing is taking one of the mappings and changing it to use a particular column type for double data.
I guess the problem here is the datatype. In my case the grid is bound to the datasource, after which I'm trying to change the datatype from string to double...
Is there a way to change the datatype of a column after the grid is bound?