Filter Builder Dialog

• Jul 30, 2021

The filter builder dialog allows end-users to:

• Build complex filter criteria with an unlimited number of filter conditions combined by logical operators.

• Save filter criteria to files, and restore previously saved criteria at a later point.

In the ExpressPivotGrid, the filter builder dialog is used to customize the prefilter‘s criteria.

The table below lists the main properties of the pivot grid which affect the filter builder dialog’s appearance and behavior:

Availability	End-users can invoke the filter builder dialog using: The Prefilter… button displayed within the prefilter panel. The Show Prefilter Builder item in the header area context menu. To programmatically invoke this dialog, call the pivot grid’s ShowPrefilterDialog method.
Appearance	The pivot grid’s LookAndFeel property.
Localization	The cxSFilter~ resource strings from the cxFilterControlStrs unit.