How to use Filter bar and formula cells with Grid Control

[Narinder]

Hello Friends,

I want to use functionality of Formula Cells with filter bar in grid control. I have been able to do these things individualy. I want both the functionality in same grid. Please tell how to do this.

Any help will be appreciated.

[haneefm]

Hi Narinder,

There is no built in support for having formula cells with filterbar in a GridControl. But one way you can do this by adding the extra column to underlying datatable of the virtual grid and maintain formula value in it. You can use that extra datacolumn to filter formula cells in a grid. Please refer to the attached sample for implementation and let me know if this helps.

Sample : FilterBarFormulaGrid.zip

Best regards,
Haneef