We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Remove "Drop pivot fields here to filter by"

Thread ID:





145874 Jul 11,2019 06:13 PM UTC Jul 15,2019 10:47 AM UTC WinForms 2
Tags: PivotGridControl
Bilal Raja
Asked On July 11, 2019 06:13 PM UTC


I am Using Winforms PivotGrid Control in a C# .NET application. I want to remove text "Drop pivot fields here to filter by". By any means is there any possibility to remove or change this text?

Thirupathi Bala Krishnan [Syncfusion]
Replied On July 12, 2019 01:46 PM UTC

Hi Bilal Raja 
Thanks for contacting Syncfusion support.

Currently we are checking on the reported query-“How to change the filter area header text”, we will validate and update you the further details on July 15, 2019.
We appreciate your patience until then. 

Thirupathi B.

Subburaj Pandian Veluchamy [Syncfusion]
Replied On July 15, 2019 10:47 AM UTC

Hi Bilal Raja, 
Thank you for your patience.

We have analyzed the reported query “
How to change the filter area header text in pivot grid control”. You can achieve this requirement by assigning the own text value inside the QueryCellInfo even thandler of FilterArea. Here, the text values are rendered based on the given row and column index within the event handler. 

Please refer the following code example,
# Form1.cs
       public Form1() 
        private void InitializePivotGrid() 
            // Adding ItemSource to the Control 
            this.pivotGridControl1.ItemSource = ProductSalesData.GetSalesData(); 
            // Adding PivotRows to the Control 
            this.pivotGridControl1.PivotRows.Add(new PivotItem { FieldMappingName ="Product", TotalHeader = "Total" }); 
            this.pivotGridControl1.PivotRows.Add(new PivotItem { FieldMappingName ="Date", TotalHeader = "Total" }); 
            // Adding PivotColumns to the Control 
            this.pivotGridControl1.PivotColumns.Add(new PivotItem { FieldMappingName = "Country", TotalHeader = "Total" }); 
            this.pivotGridControl1.PivotColumns.Add(new PivotItem { FieldMappingName = "State", TotalHeader = "Total" }); 
            // Adding PivotCalculations to the Control 
            this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo { FieldName = "Amount", Format = "$ #,##0.00", SummaryType = SummaryType.DoubleTotalSum }); 
            this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo { FieldName = "Quantity", Format = "#,##0" }); 
            this.pivotGridControl1.ShowGroupBar = true; 
           this.pivotGridControl1.TableControl.FilterArea.QueryCellInfo += FilterArea_QueryCellInfo; 
        private void FilterArea_QueryCellInfo(object sender, GridQueryCellInfoEventArgs e) 
            if (e.RowIndex == 2 && e.ColIndex == 1) 
                e.Style.Text = "Drop fields here"; 
                e.Style.TextColor = System.Drawing.Color.White; 

Please refer the following screenshot,

We hope this helps. Please let us know, if you would require any further assistance. 
Subburaj Pandian V 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon