I have a requirement to have a grid column display a value from a group of values like (Good, Average, Bad), but the values are actually stored as integers (0, 1, 2). I don't have a problem in displaying or editing the values, you provide excellent support for that using either the celltemplates and or combo box grid column. The problem is when I do that, the Filter control displays the actual values (0, 1, 2) yet I need to display (Good, Average, Bad) instead. I have tried using the DistinctValuesLoading event to populate the Filter screen, and it successfully populated the Filter control, and using the Filtering event and checking for Member property and changing the Value property I can make the filtering operation to work.
The issue that whenever I do that and close the Filter popup and reopen it, nothing is selected. So is this the best way to achieve this behavior? I understand that you support custom filtering controls, but I was hoping to find a simpler solution to this basic problem and avoid recreating a complete custom filter with its UI.
The other part of the question is about the grouping and how to make the group header display (Good, Average, Bad) instead of (0, 1, 2). I have tried GroupHeaderFormatString and GroupMemberPath and I can't achieve what I need.
Thank you in advance for your support.
The issue that whenever I do that and close the Filter popup and reopen it, nothing is selected. So is this the best way to achieve this behavior? I understand that you support custom filtering controls, but I was hoping to find a simpler solution to this basic problem and avoid recreating a complete custom filter with its UI.
The other part of the question is about the grouping and how to make the group header display (Good, Average, Bad) instead of (0, 1, 2). I have tried GroupHeaderFormatString and GroupMemberPath and I can't achieve what I need.
Thank you in advance for your support.