Skip to main content
All docs
V25.1
  • Column Filter for a WinForms Grid Item

    • 2 minutes to read

    Column filters (filter row and header filter allow users to search data in the Grid item. These filters do not affect data outside the Grid.

    Filter Row

    The filter row allows a user to filter data by individual column values. To display a filter row, go to the Grid’s Design Ribbon tab in the Designer and enable the Filter Row button in the Column Filter group:

    WinForms Designer - Display a filter row

    When the filter row appears, a user can enter the condition in the text box to filter column values:

    WinForms Designer - Filter row

    The filter row’s cells can be of different types–text boxes for string and numeric values, calendars for dates, and so on.

    In code, set the GridColumnFilterOptions.ShowFilterRow property to true to enable the filter row.

    Header Filter

    The header filter allows users to filter values in an individual column. A user can include or exclude values from the applied filter to show the result.

    WinForms Designer - Header filter

    The header filter is always enabled, so you cannot disable it in the UI.

    For more information about the header filter, read the following article: Filter and Search.

    Update Totals

    A user can configure a Grid item to reflect changes in column values and recalculate totals based on the applied column filters.

    To update totals, go to the Grid’s Design Ribbon tab in the Designer and enable the Update Totals button in the Column Filter group:

    WinForms Designer - Enable Totals Updates

    As a result, the Grid item recalculates totals depending on the applied column filters:

    WinForms Designer - Updated totals in a filter row

    In code, set the GridColumnFilterOptions.UpdateTotals property to true to recalculate totals.

    Limitations

    Filter Row Limitations

    The following Grid columns do not support the filter row:

    A Grid item does not support a filter row for window calculations and calculated fields that use the w-function if the Update Totals option is enabled.

    Update Totals Limitations

    You cannot enable totals recalculation in OLAP data sources.

    Other Limitations

    Although column filters within a Grid item are case-insensitive, totals are calculated on the server and their case-sensitivity setting depends on the database settings. If case-sensitivity settings are different, the total value can differ from the Grid’s data. Make sure that the Grid item and the database use the same case-sensitivity settings.