$99 VS $1000+. UI Control for ASP.NET AJAX(contains chart and gridview).
Windows Forms PivotGrid Control
Create interactive user interface of Pivot table, build summarizations and highlight specific data
Home > WinForms UI Controls > User Manual > PivotGrid Filtering in C#

Build Filtering for PivotGrid in C#.NET

KetticPivotGrid controls allow the users to add filters descriptions to your .NET application to manage the data that will be displayed. By using the data filtering functionality in KetticPivotGrid, the users can use the group filtering options to operate data to view data exactly in Pivot. These functionalities are available in context menus and dialogs that are similar to options in MS Excel for the end users. KetticPivotGrid control provides two types of filtering, the Reports filtering and the Group Filters, to filter data items and groups that will be displayed in KetticPivotGrid.

C# Reports Filtering in KetticPivotGrid

The filtering functionality is able to filter data items to be displayed in the reports which are created by the KetticPivotGrid control in C# Windows Forms applications. This feature will help the users of your application to view a report containing the records that has common properties. KetticPivotGrid control will perform the report filtering before calculating the aggregated information.

Enable the Report Filters in KetticPivotGrid in C#.NET

The default setting hides the report filters, so we need to show the report filters elements in the report filters area. The simple C# code snippet below shows how to display the report filters.

this.ketticPivotGrid1.DisplayFilterArea = true;

C# Group Filtering in KetticPivotGrid

KetticPivotGrid control provides the group filtering mechanism for the users to add filter conditions to the group descriptions in C# Windows Forms applications. By using this sorting feature, the users are able to specify the groups generated that will be shown in PivotGrid. KetticPivotGrid control contains two types of group filters available to the users.

Enable Group Filtering to KetticPivotGrid Control

To enable or disable group filtering functionality, we need to use the EnableGroupFiltering property. The default setting enables the group filtering as the C# code below.

this.ketticPivotGrid1.EnableGroupFiltering = true;
UI Controlsfor Windows Forms
.NET WinForms UI Overview.NET WinForms UI Features.NET WinForms UI GuideC# WinForms UI DesignVB.NET WinForms UI Design
WinForms UI Controls