We have certain columns in our grid that have the option of being displayed as the same as the raw data or using a converter it can be displayed with the values multiplied by 100, when using aggregates on the column however they still return the same result as when they were the raw values, is there a way to do this nicely? Using a converter on the binding for the aggregate result in the RadGridView control template has the desired effect but affects all columns which we don't want.
1 Answer, 1 is accepted
Hello Jack,
Depending on the modification you perform in the converter, you can either define a custom Footer for the column or create a custom aggregate function.
I've prepared a small sample project to demonstrate how you can define a custom footer and use the same converter for the FormattedValue property of the aggregate result.
Please have a look and let me know if the same approach would work in your original application.
Regards,
Dilyan Traykov
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
Rank 1
This behavior has been explained in the following article: Applied IValueConverter on the DataMemberBinding. As suggested, you can use an additional calculated property and then utilize the FilterMemberPath property instead of using the IValueConverter.
Another approach I can suggest based on your concrete scenario is to handle the Filtered event of the control and update the values of the filter descriptor. In the sample project I provided, this can be done as follows:
private void playersGrid_Filtered(object sender, Telerik.Windows.Controls.GridView.GridViewFilteredEventArgs e)
{
if (e.ColumnFilterDescriptor.Column.UniqueName == "Number")
{
e.ColumnFilterDescriptor.FieldFilter.Filter1.Value = (int)e.ColumnFilterDescriptor.FieldFilter.Filter1.Value / 100;
}
}