[Solved] Filtering a column using DataFormatString

[Jake]

I have several columns in a instance of RadGrid using a DataFormatString to display currency with the decimal values removed (i.e. {0:c0}).

When a user attempts to filter on any of these columns using the "Equals" filter option, nothing is returned.  I presume this is because the underlying data contains the decimal values which is what RadGrid is filtering on.

Is there a recommended way of handling this scenario?

[Veli]

Hello Jake,

You are right in your presumption. RadGrid converts the filter values to double and searches for the exact value in the data source. If you have decimal digits cut off in the filtered value, your filtered and compared values do not match.

You will need to implement custom filtering for RadGrid if you want to filter by truncated field values. You can use RadGrid's ItemCommand event:

void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.FilterCommandName)
    {
        e.Canceled = true;

        // implement your custom filtering here

        //RadGrid's data source should not contained the custom filtered data
        RadGrid1.Rebind();
    }
}

All the best,
Veli
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.